open a specific record in second form

[lebanoncedars]

Hi there,
I have two forms are related and have links between each other.One is continous form to show all customers and second to enter new reservation for a single customer.

Question: what I need, whenever I click on LastName field (Example: Smith) the LastName in form1, the second form Reservation opens with all information about Mr Smith,

Cos the 2 forms are different design, one to show all customers one time(Continous form), and second to show one customer at the time.

Thanks,
Lebanoncedars

 

[thornmastr]

I am looking at this from a different perspective.

I would use the form header to contain the continuous form showing a line by line item index of your customers. Just enough information for the users to easily distinguish between Tom Jones and Tom Jones. The detail section of the form would show detailed information for any chosen client. The form footer would be a subform showing the reservations for the selected client.

Just my $0.02 cents worth.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com