DAP Adding records to filtered page 1

[VE]

I already have the primary key of the table I want to add to on my DAP.

This DAP is accessed from a link from another DAP; it uses the server filter to go directly to the set of records that I want (the many side of a one to many).

I would like to add new records to this table, but it needs the primary key from the "one" table added to the new record.

How to do I get the new record to automatically populate the foreign key field with the record that the page is currently filtered by?

I do not know VBscript, but if this is what I need does anyone know where there is a tutorial that would cover this sort of thing and database access in the begining? I've been searching and not having any luck at all. Maybe I'm not calling it the right thing, or just looking in the wrong place. There are a lot of other things that I need to do with this, like conditional formating. Any suggestions? What do I need to study to get this done?

Thank you very much for your help.

VE

 

[fneily]

Go to MS Access How-to Articles

http://www.kayodeok.btinternet.co.uk/favorites/kbofficeaccesshowto.htm

and do a search on "data access page". You'll see links to various microsoft papers on DAP topics.

For your problem, you may want to look at:
How to Simulate a Subform or Subreport on a Data Access Page

http://support.microsoft.com/?kbid=232566

Fill Record with Data from Selected Record on a Data Access Page

http://support.microsoft.com/?kbid=234217

 

[VE]

Thank you. I will try the instructions on those links.

VE