How to find if a field exists?

#1 (**permalink**) 18-Nov-2005, 14:00 PM

Using Access 2003,

I'm trying to create a command button on a form (frmBase) that will open a
popup form (frmPopup) with related data (linked relationship of "ID" and
"ForeignID"). I can get this to work fine, HOWEVER, if there is no data (ie.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7685-how-to-find-if-field-exists.html
the ForeignID does not exist) then I want to open the form in DataEntry =
True mode. I know how to open a form in DataEntry mode, but I'm having
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7685
difficulty with the IF/Then.

So, what conditional code do I need to see if a record exists?

TIA

Aaron G
Philadelphia, PA

#2 (**permalink**) 18-Nov-2005, 14:00 PM

Can you post what you have now?

On the OnClick event I would put something like that
If Isnull(DLookUp("FieldName","TableName","Enter here the criteria") Then
' New record open in add mode
Docmd.OpenForm "FormName",,,,acFormAdd
Else
' Existing recod, open in edit mode with criteria
Docmd.OpenForm "FormName",,,WhereCondition,acFormEdit
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7685
End if
--
I hope that helped
Good Luck

"Aaron G" wrote:

> Using Access 2003,
>
> I'm trying to create a command button on a form (frmBase) that will open a
> popup form (frmPopup) with related data (linked relationship of "ID" and
> "ForeignID"). I can get this to work fine, HOWEVER, if there is no data (ie.
> the ForeignID does not exist) then I want to open the form in DataEntry =
> True mode. I know how to open a form in DataEntry mode, but I'm having
> difficulty with the IF/Then.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7685
>
> So, what conditional code do I need to see if a record exists?
>
> TIA
>
> Aaron G
> Philadelphia, PA

#3 (**permalink**) 18-Nov-2005, 14:00 PM

Ofer,

That worked perfectly. I'm to embarrased to show you the mess I was trying
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7685
to make. My blood sugar must be getting low.

As always, thanks for your help.

Aaron G
Philadelphia, PA

"Ofer" wrote:

> Can you post what you have now?
>
> On the OnClick event I would put something like that
> If Isnull(DLookUp("FieldName","TableName","Enter here the criteria") Then
> ' New record open in add mode
> Docmd.OpenForm "FormName",,,,acFormAdd
> Else
> ' Existing recod, open in edit mode with criteria
> Docmd.OpenForm "FormName",,,WhereCondition,acFormEdit
> End if
> --
> I hope that helped
> Good Luck
>
>
> "Aaron G" wrote:
>
> > Using Access 2003,
> >
> > I'm trying to create a command button on a form (frmBase) that will open a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7685
> > popup form (frmPopup) with related data (linked relationship of "ID" and
> > "ForeignID"). I can get this to work fine, HOWEVER, if there is no data (ie.
> > the ForeignID does not exist) then I want to open the form in DataEntry =
> > True mode. I know how to open a form in DataEntry mode, but I'm having
> > difficulty with the IF/Then.
> >
> > So, what conditional code do I need to see if a record exists?
> >
> > TIA
> >
> > Aaron G
> > Philadelphia, PA

#4 (**permalink**) 18-Nov-2005, 14:00 PM

Glad I could Help
Good Luck

"Aaron G" wrote:

> Ofer,
>
> That worked perfectly. I'm to embarrased to show you the mess I was trying
> to make. My blood sugar must be getting low.
>
> As always, thanks for your help.
>
> Aaron G
> Philadelphia, PA
>
> "Ofer" wrote:
>
> > Can you post what you have now?
> >
> > On the OnClick event I would put something like that
> > If Isnull(DLookUp("FieldName","TableName","Enter here the criteria") Then
> > ' New record open in add mode
> > Docmd.OpenForm "FormName",,,,acFormAdd
> > Else
> > ' Existing recod, open in edit mode with criteria
> > Docmd.OpenForm "FormName",,,WhereCondition,acFormEdit
> > End if
> > --
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7685
> > I hope that helped
> > Good Luck
> >
> >
> > "Aaron G" wrote:
> >
> > > Using Access 2003,
> > >
> > > I'm trying to create a command button on a form (frmBase) that will open a
> > > popup form (frmPopup) with related data (linked relationship of "ID" and
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7685
> > > "ForeignID"). I can get this to work fine, HOWEVER, if there is no data (ie.
> > > the ForeignID does not exist) then I want to open the form in DataEntry =
> > > True mode. I know how to open a form in DataEntry mode, but I'm having
> > > difficulty with the IF/Then.
> > >
> > > So, what conditional code do I need to see if a record exists?
> > >
> > > TIA
> > >
> > > Aaron G
> > > Philadelphia, PA