using a paramater passed to a query to populate a form field

jonnycattt

Registered User.
Local time
Today, 10:31
Joined
Sep 29, 2001
Messages
20
Hi all,
I have a query that prompts for a parameter, and I have a form that uses that query. So I open the form, enter the number (in this case, it's an "issue number", and then all records for that issue are available in the form. Now, here's my problem:

When I go to enter a new record, I need to have that issue number auto-inserted into the appropriate spot on the form. Currently, when I go to new record, that form field just remains empty. I can't fix it by entering a default value in the table, because the field doesn't lend itself to defaults; nor, can I fix it by entering a default value into the form itself....unless there's a way I can use that query input parameter to populate that default value.

Any advice?

Thanks a lot.
 

Users who are viewing this thread

Back
Top Bottom