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.
 
K

Klatuu

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

Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Bridge Club Player selection Form 0
Dynamic Naming of Form Button 3
Table reference changed after design master conversion 2
Appending in a sub form 5
Height and position of a form 3
Need a Database... Will Pay (A Little) 6

Top