Lets assume you have SearchCrit as a text box on your form.


Private Sub SearchCrit_AfterUpdate()
Dim x As String
x = Screen.ActiveControl.Value
MsgBox x
End Sub

------

Instead of MsgBox put x in your SQL

David -
I just realized I may have just steered you in the wrong direction.

  First the scope of the variable x is Private so it will "be lost" once you move on to the SQL for the Combo.  
I suppose you could make it a Public Sub.  BUT...  That brings me to the next issue.

I just noticed that you have started the Expert series and this isn't covered until the Developer 25 course.  I don't know if you even have any experience with VBA.

So...  Scratch that and let me think a little more on how to bet guide you.  My apologies.

typo - best guide you not bet

Can you give me an example and / or post a screen shot of what you are wanting to do?
You can upload a picture by clicking the Upload Images in the top right of your original post.

I have done a bit of VBA in excell, so I know the basics.

If you have a look at the table relationships, I have aircraft make and model tables, then an aircraft register table. In a form based on the register table I am creating a new record (or editing an existing record). I select the aircraft make from a combobox based on the ACMakeT. Then I select the aircraft model from another combobox based on the selection of the first combobox and giving a selection from ACModel in ACModelT. I can get the first combo box to work, but not the second.

Boy I was sure trying to overthink that one.  LOL
I really missed the point of the original question.  Sorry.

The Cascading video should help you get this going.  If,  after watching that and playing a bit, come on back.  and we'll troubleshoot it.

A dirty record is one that hasn't been saved to the table yet. As long as you haven't committed the changes (moved off the record or refreshed) then you should just be able to hit ESCape and get the old (previous) data back.