Getting Data From other Form or Forms in MS Access 2003

[Guest]

Hi All,

I want that in my forms I get data from other forms, let me take an example,
I have Customer form where I have customer Region or Country field etc. When
I enter in country field from dbl click event or with the help of command
button etc. a form open which contains all country names, when I click any of
the country name in this form it updates the country field in my customer
form, I just dont want to use a combo box or list. please help me in this
matter

 

[bhipwell via AccessMonster.com]

Although it is highly recommended that your form fields pull from tables or
queries, you can make a field display information from another form using the
following code in the control source:

=[Forms]![TheFormName]![TheFormFieldName]

Hopefully this is what you were looking for.

B