drop down control displaying records in form

J

JAdams

I have a form that is for display only. The query that the records come from has a field called status. I want to have an afterupdate event on a combo box that will requery the form and display the status requested.

Here is the not worked out if statement:

If status = "Status" Then
Exit Sub
ElseIf "Open" Then
'Query should be "Open" in criteria
requery
ElseIf status = "closed" Then
'Query shoule be "Closed in criteria
requery

ElseIf status = "all" Then
'Query should be "" in criteria
requery
Else
MsgBox "An error has occured please contact you systems administrator", vbInformation
End If


How do I go about this? It is probably easier than I think. Thanks
 

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

Lock Control based on User 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
iif exists - too complex? 0
Access 2007 Combo Box Search 3
sorting a screen and combo locks 3
Testing for required data entry in form fields. 6
Another Sub Form requery question 1
Subform Requery Criteria 1

Top