Help with code

[andsweet]

I have adapted the Service Management DB that comes with Access. I would like to perform the following:

I have form A. This contains details of customers. Inside from A is a subform A1. This contains details of all jobs for the customer that is being viewed. On form A there is a command button which will open form B to enter job details for the customer that is being viewed on form A. On form B there is a text box where details of the job are described. I need this text box to display the information on form A1 .

The problem is that when viewing form A, form B is not open and therefore does not display any information on form A1 (I get #NAME or #Error).

I know this is confusing describing it this way but it may help those who do not have access to the Service Management sample DB

Form A = Workorders by customer
Form A1 = Workorder by Customer Subform
Form B = Workorders

Any help will be appreciated.

Thanks

 

[namliam]

You cannot get information from a closed form.
You have to either hide it (keeping it open to be able to fetch information from it)

Or

Add the table which is the bases for Form B to your query for Form A1

Or

Add a subform to Form A1 which will display the information

Or

Use a DLookup

Or .... probably some other ways to solve this but the above ones will work best (not necesaraly in that order tho...)

Greets

 

[Rich]

Why not just enter the job details directly onto A1 ?