Access 2003 help: Selecting record with unbound...

  Radix Lecti 10:25 24 Dec 2007

Hi all, I've done this several times in the past (4-5 years ago), but I just can't remember how to do it now!

I have a form, feeding off a query of a table. All's working great, but I want an unbound combo-box control to be able to select records with on this form.

Thing is, for each record I have a table field called Ref_No and on the query, I have a 'made-up' field (sorry, forgot the proper term), which creates a longer reference number, based on about 3 different fields from the table/query.

This 'concatenated' reference number works a treat, and although I've added an unbound combo-box control to the form, which lists all of these concatenated reference numbers (representing each record), it doesn't seem to allow me to actually go to the record of the reference number I select in the combo-box.

I'm sure this should be easy... any ideas where I'm going wrong?

Thanks all!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Lightwell software lets you create mobile apps without using code

Best value Mac: Which is the best £1249 Mac to buy

Comment désactiver les programmes qui s'exécutent au démarrage de Windows 10 ?