Microsoft in there infinite wisdom added the action catalog for creating common macro actions; however they really don't spend the time to express how to use this function.
Well on to my problem. I have two tables one with lets call it description data and one with numbers lets call it just numbers.
I have a form with a search button and a text box. Then I have the fields for the Description data and the Numbers.
This part of the form works fine and I can roll/scroll through the records one at a time and all the fields show correctly so everything is in sink.
I would like to use the action catalog (so I can learn) to activate a click action on the search button to search for a specific number 'MS1095'.
If I can do this I think I know how to call up a value from the text box when I'm ready.
Thanks for your help.
P.S.
I want to populate the form with the record not just access the record in a table?
Found this little bit of code that worked perfectly (didn't use the action catalog but it got me closer):
Option Compare Database
Private Sub FindCBT_Click()
Dim sSearch As String
'read the seach string from the form
'note: NZ() ensures that nulls are converted to empty strings
sSearch = Nz(Me.FindTextBox, "")
'Check if the search string is empty or not and set the filter accordingly
If sSearch = "" Then
Me.Filter = ""
Else
Me.Filter = "[SearchFeild] LIKE '*" & sSearch & "*'"
End If
'turn on the forms filter
Me.FilterOn = True
End Sub