In Access 2007 I have two forms - one called Customers and the other called SWZ. There is no relationship between the two forms. The SWZ form has two fields Account Number and Application Number. The Account Number field is prepopulated with Numbers.
The customer form also has two fields one called Appno and the other is called AC number . Appno is prepopulated with numbers.
I need to do the following from the customer form:
Open the swz form and populate the first record Application Number field from the Appno field on the Customer form
Then take the Account Number from the same record in the SWZ form and populate the AC number field in the Customers form.
I havent got a clue where to start.
Help please