Hi all
Ok, I'll try and explain this as clearly as possible
I've got a combo box, where the user selects a reference number.
A query uses this reference number to return all details in the record relating to it.
A form uses the results returned from the query to show all of the details which the user can then update.
Standard stuff so far huh?
BUT!
What I want to happen, is, when the query returns the results - there is a 'Category' field which contains either A,B,C or D.
I have an A form, a B form, a C form and a D form.......
I want the correct form to open based on the 'Category' result from the query.
Does anybody know how I do this?
Many thanks!!
Yet
Ok, I'll try and explain this as clearly as possible

I've got a combo box, where the user selects a reference number.
A query uses this reference number to return all details in the record relating to it.
A form uses the results returned from the query to show all of the details which the user can then update.
Standard stuff so far huh?
BUT!
What I want to happen, is, when the query returns the results - there is a 'Category' field which contains either A,B,C or D.
I have an A form, a B form, a C form and a D form.......
I want the correct form to open based on the 'Category' result from the query.
Does anybody know how I do this?

Many thanks!!
Yet