18-Nov-2005, 14:00 PM
|
 | Guest | | | | | | | | |
| RE: How to find if a field exists?
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
> > --
> > 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 =
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7685-how-to-find-if-field-exists.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7685
> > > 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  |