It should be as follow
Put it in the event of on click of the customers list in your pop up form,
that will return the value from the list in your pop up form called customer,
to your field customer id in the main form called loads.
Forms![Loads]![CustomerID] = Me.CustomerID
(that meen that main form called loads, the field on the main form that
suppose to get value called CustomerID , and the list on the pop up called
CustomerID)
I hope I understood corectly.
Mike said:
Thanks for the help Ofer, but I get an error.
The form that I want to put the info in is called Loads and the popup I want
is called Customers. I set the double click event in Loads.customerID as
follows
Forms![Customers]![CustomerID] = Me.CustomerID
Did I screw up? The customers form is a pre-existing one, do I need to
change it?
The error I get is Run time error 2450. Microsoft Access can't find the form
'Customers' referred to in a macro or VB code.
Please help.
Mike
Ofer said:
On the double click event of the customer list add the code
Forms![FormName]![CustomerName] = me.customerlistname
use it only if you open it from one form, but if you can open the customer
list from few forms, then save the name in global variable and after you
close the form assign that value to your main form.
:
Hi everyone,
How can I set up a new form to open to select a customer from the customer
table? I want sort of a pop up table that the user can double click
on
a
record and get that customer name into the orders table. Currently I am
using combo boxes but I'd prefer popup forms. I think it's really
easy
for
many of you and I am having a mental block about it.
Thanks
Mike
