I created a wizard type form system, but it doesnt seem to want to work if theres nothing in the next form.
For instance I have a customer form with a Customer ID (tblCust),
a button on this form opens an order form (tblOrder), which has a customer ID and an order ID.
I used the button wizard to create a button that links the two CustomerIDs together.
(form operations > Open Forms > tblOrder > "open the form and find specific data to display" > "CustomerID" <-> "CustomerID" > Finish)
Which seems doesnt seem to have the right effect when I test it out.
I think its because the CustomerID doesn't yet exsist in tblOrder. How would I get around this? I am trying to create a data entry wizard to eventually create and print out invoices.
(open one form, enter some data, open the next form, save the data, close the last form etc...)
I have a rough outline of the idea attached
(.mdb 2000 format although I do use 2007)
For instance I have a customer form with a Customer ID (tblCust),
a button on this form opens an order form (tblOrder), which has a customer ID and an order ID.
I used the button wizard to create a button that links the two CustomerIDs together.
(form operations > Open Forms > tblOrder > "open the form and find specific data to display" > "CustomerID" <-> "CustomerID" > Finish)
Which seems doesnt seem to have the right effect when I test it out.
I think its because the CustomerID doesn't yet exsist in tblOrder. How would I get around this? I am trying to create a data entry wizard to eventually create and print out invoices.
(open one form, enter some data, open the next form, save the data, close the last form etc...)
I have a rough outline of the idea attached
(.mdb 2000 format although I do use 2007)
