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.
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.