Combo Box Add All Records.

[jeremy0028]

I have a combo box on a form called Insurance

which looks up a table call tbladdinsurance
InsuranceId(Pk)AutoNumber
Insurance Name

Instead of just selecting one record frm tbladdinsurance I want to select all records


any ideas

 

[THWatson]

Jeremy
Have a look at this link...

http://support.microsoft.com/?kbid=210290

You will note there are two methods mentioned. I have used the second method, using a Union Query.

Tom