Comboboxes displaying information

[soorags]

I have a form called frmNz in which I would like already existing data to appear in the comboboxes.

For example, in the Business Name combobox I begin to type Can... and "Canalside Ltd" appears, ready to be selected.

Or, in the Country combobox I begin to type Unite... and "United Kingdom" appears, ready to be selected.

The same for the Website and Email address comboboxes. How can I do this?
I have attached the file. The data comes from the UK Table.

Gurdip.

 

[Michael J Ross]

Set the Data Source for each combo box to (replacing name with required field name) :

SELECT [UK Table].[Name] FROM [UK Table] ORDER BY [Name];

 

[soorags]

Data Source

When you say Data Source do you mean Control Source?

 

[Michael J Ross]

Sorry it's Row Source

 

[soorags]

It works.

It works now except for the Website and Email Address comboboxes when enabled. How can I make them work?

Gurdip.

 

[soorags]

Here is the working attachment.

Here is the attachment, but the website and email address comboboxes don't do the same when enabled. How can I make them work?

Gurdip.

 

[Michael J Ross]

Hi,

The websites and emails are there, it's just because of all the blanks, to get round it amend the code to

SELECT [UK Table].[Website Address] FROM [UK Table] Where [UK Table].[Website Address] Is Not Null ORDER BY [Website Address];