Access 2003 help: Selecting record with unbound...

  Radix Lecti 10:25 24 Dec 07

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.

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…