Klatuu said:what is the row source of the combo?
The user would select from the combo's list
--
Dave Hargis, Microsoft Access MVP
bbypookins said:Okay. I created an unbound combo box called cboFindRecord and entered your
code in the AFter Update event. Now how does the user utilize this?
Klatuu said:First, lets use a differnt name. I believe SeqNumber is the text box that is
bound to the SeqNumber field in your recordset.
I prefer to use prefixes on my names, so I know immediately what they are,
for example, all text box controls start with txt, so the text box would be
named txtSeqNumber. And a combo box would start with cbo.
Now, you your case, you need to find the division and the sequence number.
You will need to search using both of those values.
Let's call it cboFindRecord
Private Sub cboFindRecord_AfterUpdate
With Me.RecorsetClone
.FindFirst "[SeqNumber] = " & Me.SeqNumber & " AND [Division] = '" &
Me.Division & "'"
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With
End Sub
bbypookins said:I'mworking on my database again. Here is the last question I asked that I
knowyou didn't see. It's in regards to your previous response to me...
What is it supposed to be? I'm confused.
Klatuu said:what is the row source of the combo?
The user would select from the combo's list
--
Dave Hargis, Microsoft Access MVP
bbypookins said:Okay. I created an unbound combo box called cboFindRecord and entered your
code in the AFter Update event. Now how does the user utilize this?
:
First, lets use a differnt name. I believe SeqNumber is the text box that is
bound to the SeqNumber field in your recordset.
I prefer to use prefixes on my names, so I know immediately what they are,
for example, all text box controls start with txt, so the text box would be
named txtSeqNumber. And a combo box would start with cbo.
Now, you your case, you need to find the division and the sequence number.
You will need to search using both of those values.
Let's call it cboFindRecord
Private Sub cboFindRecord_AfterUpdate
With Me.RecorsetClone
.FindFirst "[SeqNumber] = " & Me.SeqNumber & " AND [Division] = '" &
Me.Division & "'"
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With
End Sub
Klatuu said:I thought I had posted a response. I know it was quite involved. I will go
back and find the other post and get back to your. Sorry for the delay.
--
Dave Hargis, Microsoft Access MVP
bbypookins said:I'mworking on my database again. Here is the last question I asked that I
knowyou didn't see. It's in regards to your previous response to me...
What is it supposed to be? I'm confused.
Klatuu said:what is the row source of the combo?
The user would select from the combo's list
--
Dave Hargis, Microsoft Access MVP
:
Okay. I created an unbound combo box called cboFindRecord and entered your
code in the AFter Update event. Now how does the user utilize this?
:
First, lets use a differnt name. I believe SeqNumber is the text box that is
bound to the SeqNumber field in your recordset.
I prefer to use prefixes on my names, so I know immediately what they are,
for example, all text box controls start with txt, so the text box would be
named txtSeqNumber. And a combo box would start with cbo.
Now, you your case, you need to find the division and the sequence number.
You will need to search using both of those values.
Let's call it cboFindRecord
Private Sub cboFindRecord_AfterUpdate
With Me.RecorsetClone
.FindFirst "[SeqNumber] = " & Me.SeqNumber & " AND [Division] = '" &
Me.Division & "'"
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With
End Sub
bbypookins said:Were you able to find your response? I can't see it anywhere.
Klatuu said:I thought I had posted a response. I know it was quite involved. I will go
back and find the other post and get back to your. Sorry for the delay.
--
Dave Hargis, Microsoft Access MVP
bbypookins said:I'mworking on my database again. Here is the last question I asked that I
knowyou didn't see. It's in regards to your previous response to me...
What is it supposed to be? I'm confused.
:
what is the row source of the combo?
The user would select from the combo's list
--
Dave Hargis, Microsoft Access MVP
:
Okay. I created an unbound combo box called cboFindRecord and entered your
code in the AFter Update event. Now how does the user utilize this?
:
First, lets use a differnt name. I believe SeqNumber is the text box that is
bound to the SeqNumber field in your recordset.
I prefer to use prefixes on my names, so I know immediately what they are,
for example, all text box controls start with txt, so the text box would be
named txtSeqNumber. And a combo box would start with cbo.
Now, you your case, you need to find the division and the sequence number.
You will need to search using both of those values.
Let's call it cboFindRecord
Private Sub cboFindRecord_AfterUpdate
With Me.RecorsetClone
.FindFirst "[SeqNumber] = " & Me.SeqNumber & " AND [Division] = '" &
Me.Division & "'"
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With
End Sub
Now, you your case, you need to find the division and the sequence number.
You will need to search using both of those values.
Let's call it cboFindRecord
Private Sub cboFindRecord_AfterUpdate
With Me.RecorsetClone
.FindFirst "[SeqNumber] = " & Me.SeqNumber & " AND [Division] = '" &
Me.Division & "'"
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With
End Sub
bbypookins said:Don't worry about hurrying. You're doing me an enormous favor. Here's where
I'm at.
You gave me this:
Now, you your case, you need to find the division and the sequence number.
You will need to search using both of those values.
Let's call it cboFindRecord
Private Sub cboFindRecord_AfterUpdate
With Me.RecorsetClone
.FindFirst "[SeqNumber] = " & Me.SeqNumber & " AND [Division] = '" &
Me.Division & "'"
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With
End Sub
I responded with this:
your code in the AFter Update event. Now how does the user utilize this?
To which you replied:
And my latest question was:
Klatuu said:Yes, but you have been waiting a long time and being very patient.
I am really sorry.
It is quitting time, so I will get on it first thing in the morning.
--
Dave Hargis, Microsoft Access MVP
bbypookins said:Don't worry about hurrying. You're doing me an enormous favor. Here's where
I'm at.
You gave me this:
Now, you your case, you need to find the division and the sequence number.
You will need to search using both of those values.
Let's call it cboFindRecord
Private Sub cboFindRecord_AfterUpdate
With Me.RecorsetClone
.FindFirst "[SeqNumber] = " & Me.SeqNumber & " AND [Division] = '" &
Me.Division & "'"
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With
End Sub
I responded with this:
your code in the AFter Update event. Now how does the user utilize this?Okay. I created an unbound combo box called cboFindRecord and entered
To which you replied:
what is the row source of the combo?
The user would select from the combo's list
And my latest question was:
What is it supposed to be? I'm confused.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.