Lookup field to display more details

[snowygirl1]

I have a form I've set up for some courses.


I have set up a table for "courses" and another table for "venues" as we may use the same venue for multiple courses.
Whenever I create a new course, I want to select a venue from a lookup field (which is linked to the courses tables), and then have the address and other information pulled from the venue table and just displayed on the form. I cannot get it working.

Any suggestions???

[Bob Fitz]

On a form, use a combo box based on the venue table, to select the venue. The combo and be set to include all the fields from the table but hidden. Text boxes on the form can then reference the different (hidden) columns of the combo as their Record Source property. Remember that the columns are numbered starting with zero. So first column is =MyCombo.Column(0) second column is MyCombo.Column(1) etc

[snowygirl1]

Ok I have created the combo box but I'm not sure how to hide all the fields with the exception of the venue name.
Here is the row source: SELECT [tbl_Venue].[VenueID], [tbl_Venue].[Venue Name], [tbl_Venue].[Address], [tbl_Venue].[Suburb], [tbl_Venue].[State], [tbl_Venue].[Postcode], [tbl_Venue].[Contact Name], [tbl_Venue].[Contact Email], [tbl_Venue].[Contact Phone] FROM tbl_Venue ORDER BY [Venue Name];

[Bob Fitz]

Change he Column Widths property of the combo to something like: 0cm;2;0cm;0cm;0cm;0cm;0cm;0cm;0cm;

You'll probably want to reduce the List Width Property as well.

Simple example attached:

[snowygirl1]

Thank you Bob. I have managed to get it working thanks to your assistance. Greatly appreciated.

[snowygirl1]

Opps no one more issue. When i allocate the venue for each course, it is not saving this. So if i exit out of the form and go back in the venue is blank again.

[Bob Fitz]

Thank you Bob. I have managed to get it working thanks to your assistance. Greatly appreciated.

You're welcome. Glad I was able to help

[Bob Fitz]

Opps no one more issue. When i allocate the venue for each course, it is not saving this. So if i exit out of the form and go back in the venue is blank again.

Sounds like you need to set the Control Source property of the combo to the appropriate field of the forms Record Source

[snowygirl1]

Sorry yep realised that after I'd replied.. All working now. Thank you for your time.