05-Nov-2005, 12:48 PM
| || |
| || || || || |
| || |
Re: Linking two Forms
Microsoft Access MVP
Secret Squirrel wrote:
> But will that second form always open to that specific record if it's
> tied into the first record?
> "Joan Wild" wrote:
>> From form one...
>> DoCmd.OpenForm "SecondForm", , , "[SomeID] =
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6661-linking-two-forms.html
>> Joan Wild
>> Microsoft Access MVP
>> Secret Squirrel wrote:
>>> I have a form where users will do all their data entry. I have
>>> another form where they can add additional information for that
>>> particular record. The can click on a command button to access this
>>> other form. But when they click on this button I want to be able to
>>> carry over the Primary key field (the autonumberID) and have it
>>> populate a field on this other form. This way I can tie the two
>>> tables together. But here's the catch, I want people to also access
>>> this other form via the switchboard as well without carrying over
>>> the Primary Key from that main form. There are two way to create a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6661
>>> record on this form. One is directly and the other is through the
>>> main data entry form. There are two ways a record can be generated.
>>> Am I making sense here?