Daveisalwayshere
Registered User.
- Local time
- Yesterday, 19:28
- Joined
- Mar 14, 2014
- Messages
- 31
Hi I have a set of linked forms that usher the user through a series of forms inorder to create a quote the forms have 2 fields each and then subforms attached to them.
the forms are linked like this
SalesNUM(PK)---
---------------------->SalesNumID(FK)
------------------------QuoteNum(PK)----
---------------------------------------------->QuoteNumID(FK)
------------------------------------------------ProjectNum(PK)----
----------------------------------------------------------------------->ProjectNumID(FK)
-------------------------------------------------------------------------ScaffoldTagNum(PK)
This works wonderfully as when i press the command button to open the new page it opens the new form and filters the form based on the FK but i want the form to open showing a new record but still carrying the FK into the Text box on the form. And when i create a new Record i need it to retain the FK Basically i dont want the user to be able to adjust this at all he has already set it up in the previously linked form. is there a way to do this? I am brand new at this so figuring out a macro for that button is out of my realm.
the forms are linked like this
SalesNUM(PK)---
---------------------->SalesNumID(FK)
------------------------QuoteNum(PK)----
---------------------------------------------->QuoteNumID(FK)
------------------------------------------------ProjectNum(PK)----
----------------------------------------------------------------------->ProjectNumID(FK)
-------------------------------------------------------------------------ScaffoldTagNum(PK)
This works wonderfully as when i press the command button to open the new page it opens the new form and filters the form based on the FK but i want the form to open showing a new record but still carrying the FK into the Text box on the form. And when i create a new Record i need it to retain the FK Basically i dont want the user to be able to adjust this at all he has already set it up in the previously linked form. is there a way to do this? I am brand new at this so figuring out a macro for that button is out of my realm.
Last edited: