jokelogpop
Registered User.
- Local time
- Today, 14:35
- Joined
- Oct 16, 2004
- Messages
- 22
Hello to all Access experts,
Can someone tell me how to put and code a "Find Record" Group Option on a form with some other conditions?
The problem is here:
I have a Table: tblComputerManagement with Field: Field_ID , Field_Date and Field_Null
And a Form linked to tblComputerManagement like this:
What I wish is that when the user click on an Option, the cmdFindRecord will search the record that has these conditions and show in form:
1. The value of Toggle Button = Field_ID
2. The Field_Date <> Null
3. Field_Null = Null .
And If there is no record accompany with these, add new record.
I search in this Forum and found this code:
Private Sub Form_Load()
Me.RecordsetClone.FindFirst "Isnull([Subject]) And Isnull([Date])"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
It work well but when I add more than these two conditions with the dim of Toggle value, It cannot!
Can you give me a guide !! Thanks all!
Can someone tell me how to put and code a "Find Record" Group Option on a form with some other conditions?
The problem is here:
I have a Table: tblComputerManagement with Field: Field_ID , Field_Date and Field_Null
And a Form linked to tblComputerManagement like this:
What I wish is that when the user click on an Option, the cmdFindRecord will search the record that has these conditions and show in form:
1. The value of Toggle Button = Field_ID
2. The Field_Date <> Null
3. Field_Null = Null .
And If there is no record accompany with these, add new record.
I search in this Forum and found this code:
Private Sub Form_Load()
Me.RecordsetClone.FindFirst "Isnull([Subject]) And Isnull([Date])"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
It work well but when I add more than these two conditions with the dim of Toggle value, It cannot!
Can you give me a guide !! Thanks all!
