good afternoon -
I have what I believe is a simple coding question, but I'm not having much luck on my own and hope someone can help:
I'm working in Access 2007, and I have a form where basic information is added (FRM_GAMES). Each new record generates an autonumber primary key (GAME_ID). The user then clicks a command button to open a related child form (FRM_GAME_DATA) into which they will edit or add information. I would like the GAME_ID lining field to be automatically filled in for each new record. I believe I need to add a filter to the basic code in order to do this. Can anyone tell me what I need to add and where?
stDocName = "SUBFRM_GAME_DATA"
stLinkCriteria = "[GAME_ID]=" & Me![GAME_ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Thank you in advance for any help you can provide.
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar