I successfully created a form and a search box within Access using a VBA code. I am tasked with performing another search but now each unique identifier has multiple data associated with them that I need identified in my search form. Does anyone know how I can update the code to show these changes?
Thanks for the help.
Code:
Private Sub Form_Load()
DoCmd.Restore
End Sub
Private Sub cmdSearch_Click()
Dim strWinsRef As String
Dim strSearch As String
Exit Sub
End If
'----------------------------------------------------------------------------
'Performs the search using value entered into txtSearch
'and evaluates this against values in strWins
DoCmd.ShowAllRecords
DoCmd.GoToControl ("strWins")
DoCmd.FindRecord Me!txtSearch
strWins.SetFocus
strWinsRef = strWins.Text
txtSearch.SetFocus
strSearch = txtSearch.Text
End If
End Sub
Take a look at this video and see if it answers your needs. If not, then post back.
http://www.datapigtechnologies.com/f...earchform.html
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks