Few Combo Box Questions and Navigation Buttons

[KristenD]

As I am slowly learning more and more of what Access can do and refining my program (as I am finding out it will never be quite finished) , I am wondering about a few things.

1. On my Main Form I would the find record button tied to one field so I don't have to get out of the tabbed form to click in the field in order to search for a specific record.

2. Can on my tabbed forms set up the tab control so the forms automatically reset to the beginning and not create a new record?

3. I want a msg box or something to pop up on one of the tabbed forms with a combo box if a certain list item is selected. For example in the combo box in the form "Craft" is selected from the list the I want the program to say please enter a Craft Code or something. I don't think I want a value list in there but there may be a possibilty I might. I know it should have something to do with an event but I've searched and googled and cannot find exactly what to do and I keep going through Back ups trying to figure all three of these out.

Thank you!!

 

[KristenD]

I would like the "Find Record" button to automatically tie back to the Employee ID like I have circled in the attachment. I know there is a way on the Event Procedure but I am not sure of the wording and I have done a lot of searches to get me pointed in the right direction but I got nothing so far!

Please help!

 

[KristenD]

I tried to get this code to work but it is not popping up a message box.

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Nz(EmploymentStatus, "") = "Active" Then
    MsgBox ("This Employee is Currently Active.  Please enter a Job Number or change the Employment Status.")
    EmploymentStatus.SetFocus
    Cancel = True
End If
End Sub

 

[Rx_]

Can you explain a little more? Are you trying to grab the Employee ID and write it to the lower record with the job ID?
Let me also suggest that you spend a little time here:
http://www.access-programmers.co.uk/forums/forumdisplay.php?f=64
These are some nice, examples. Find a few and download them to review them.
There is probably an example (or three exmples) of doing what you are looking for.
These often give me an idea of how something works or how an idea might improve my existing design.