Form which runs a query to use in a look up validation of later entry

[michaelxhermes]

Form which runs a query to use in a look up validation of later entry

I have a query which uses the form value as the selection criteria - this works

I have 2 entries on the form customer and instructor id.

How do I have a second entry which is a look up based on a query depending on the other form value ?

I cannot get this to work.. when the top id changes the look up list based on the query should change...

"The list of instructors available for selection should be restricted to those that match the level of
the customer."

I have attached the database I am using.



Many thanks for your help and advice

[aytee111]

Add an unbound textbox to the form, Level. In the AfterUpdate of the customer:
Me!Level=Me!customer.Column(4)
Me!instructor.Requery

Then in the query for the instructor, set the criteria as you did in your second db - altho the instructions above say it must be the same level, not the same customer.

[michaelxhermes]

Thanks, I will try this.. much appreciated.

[davegri]

Option Compare Database
Option Explicit


Private Sub customer_ID_AfterUpdate()
 instructor_ID.RowSource = "SELECT [Instructor Details].[Instructor ID], [Instructor Details].[Instructor name], " _
 & "[Instructor Details].[Instructor level], [Instructor Details].[Lesson price adult], " _
 & "[Instructor Details].[Lesson price child] FROM [Instructor Details] " _
 & "WHERE [Instructor Level]= '" & customer_ID.Column(4) & "';"
End Sub

Add this code to the booklesson form.