Open sub forms with linked record if it exists, otherwise a new record

Open sub forms with linked record if it exists, otherwise a new record

Post by aeili » Sat, 02 Oct 2004 22:35:12


I have a main form with several sub forms as pop ups. Each is linked
to a seperate table, all of which are linked by ID.

I would like the subforms to open on the relevant record, if it
exists, but otherwise as a new record (recording the ID from the main
form).

Can anyone help?
 
 
 

Open sub forms with linked record if it exists, otherwise a new record

Post by Marshall B » Sun, 03 Oct 2004 03:41:48


The Link Master/Child properties are normally used for this.
Have you tried using them? if you did, what went wrong?

--
Marsh
MVP [MS Access]

 
 
 

Open sub forms with linked record if it exists, otherwise a new record

Post by aeili » Tue, 05 Oct 2004 23:48:15


Thanks for your suggestion. The problem is I need these forms to be
pop-up forms. I have created them as standard forms, for data entry,
opened either by a command button or from the 'onClick' event of a
check box on the main form.

There is no space for subforms to be embedded on the main form. The
main form contains information users will reference while filling the
'sub' forms.

I guess I might be missing something elementary here. My only
solution so far has been to pass IDs between forms for synchronising
them and I havn't been able to come up with a method for opening the
form on a new record if no linked record exists.
 
 
 

Open sub forms with linked record if it exists, otherwise a new record

Post by Marshall B » Wed, 06 Oct 2004 02:37:23


How about opening the related forms to just the related
records, instead of positioning the form to the record(s) of
interest? This is easy to do by using the OpenForm method's
WhereCondition argument.

As long as the related forms are not restricted to just
editing existing records, the new record area will always be
there, so, if there are no existing related records, the new
record area will be the only thing displayed.

Maybe I'm missing the point of your problem because I just
don't see anything tricky here??

--
Marsh
MVP [MS Access]
 
 
 

Open sub forms with linked record if it exists, otherwise a new record

Post by aeili » Wed, 06 Oct 2004 19:30:49

You're right, I was reinventing the wheel. Thanks for considering the
problem. It seems a common stumbling block, from searching the
forums, so for the record I used this code, in the onClick event of a
check box:

Dim stDocName As String
Dim stLinkCriteria As String

If chkTheme1 = -1 Then 'So it opens when the check is filled, not
unfilled

stDocName = "Priority1entry" 'Name of Form to open

stLinkCriteria = "[actID]=" & Me![actID] 'actID is the linking
field
DoCmd.OpenForm stDocName, , , stLinkCriteria

aeilie