Combo Boxes

S

ShaunP1989

Hi there,

I have a form which has very details on it. One of the combo boxes is
to do with Venue of the course. The Course table has the field Venue ID
in it, however in the combo box for the user to select the venue I
would like it to display the Venue name instead of the the ID. However
the is no relationship in access between the Venue table and the Course
table. The database is mostly SQL based.
 
G

Guest

Use a query based on the Venue table. The row source for a combo does not
have to be based on the form's record source. To make it easy for users,
include both the name and Id in your query. Make your combo 2 columns with
the ID being the bound column. Then you can show only the name by making the
column width of the id column 0.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box query 6
Concert footage from iPhone 12 4
Auto populate field issue 10
Plus sign on datasheet forms not showing 1
Height and position of a form 3
Table reference changed after design master conversion 2
Cascading Fields in a form 1
SUMPRODUCT query 3

Top