copying combobox selected value to form (1 Viewer)

exaccess · Dec 21, 2018

Hi Experts,
Here is the problem:
Association is the name of a combobox on current form. When the user comes to the form this field may or may not be populated, IF it is not populated and he tries to do something else then he is warned. Thus to go further it must be populated. The data will come from the selected row of the bounded one-column combobox. I am new to access and use it rarely. Can anyone help me please. It is probably a couple of lines of code. Thanks in advance.

Ranman256 · Dec 21, 2018

why cant the combo be populated at the start?

exaccess · Dec 21, 2018

Ranman256 said:
why cant the combo be populated at the start?

Because at the beginning the system does not know anything. It is first up to the user to give the name of a file, which may change each time the program is executed. The application uses the name of that file to select the combobox entry. I hope this is clear enough.

Ranman256 · Dec 21, 2018

so the user gives a filename, then what populates inside the combo?

can you have a table , with items the user can pick (the file) ,then in col2 (a query)
fill the cbo with that query?

exaccess · Dec 21, 2018

Ranman256 said:
so the user gives a filename, then what populates inside the combo?

can you have a table , with items the user can pick (the file) ,then in col2 (a query)
fill the cbo with that query?

I will try this and come back.

exaccess · Dec 24, 2018

Yes I have already tried that, now done it again and it works. Probably a typo. Thank you.

copying combobox selected value to form (1 Viewer)

exaccess

Registered User.

Ranman256

Well-known member

exaccess

Registered User.

Ranman256

Well-known member

exaccess

Registered User.

exaccess

Registered User.

Similar threads

Users who are viewing this thread