A
asmehmeh via AccessMonster.com
Happy New Year!
I’m having a small new years hiccup, I’ve got a form (working in the header
section and referencing to the detail section):
Basically the code in the header looks up a record in the detail section
where the number in the “barcodetxtbox†text box matches the value of the
record's “barcode†field.
If the text in the “bookstxtbox†text box matches the value of the that
record's “books†field then it writes a value to that field, if it doesn’t
then it writes a different value to the same field:
If Not IsNull("[books] = '" & Me.[bookstxtbox] & "' And [barcode] = " & Me.
[barcodetxtbox) Then
[book] = "Out of"
Else
[book] = "In to"
End If
Pretty simple yes? The problem is that because it’s in the header section it
seems that it is not selecting a record but is writing the values “Out of†or
“In to†in to random records.
I’m I am correct in the above then I think I need some way to select the
record (found in the IF statement).
Thank you for any help!!
I’m having a small new years hiccup, I’ve got a form (working in the header
section and referencing to the detail section):
Basically the code in the header looks up a record in the detail section
where the number in the “barcodetxtbox†text box matches the value of the
record's “barcode†field.
If the text in the “bookstxtbox†text box matches the value of the that
record's “books†field then it writes a value to that field, if it doesn’t
then it writes a different value to the same field:
If Not IsNull("[books] = '" & Me.[bookstxtbox] & "' And [barcode] = " & Me.
[barcodetxtbox) Then
[book] = "Out of"
Else
[book] = "In to"
End If
Pretty simple yes? The problem is that because it’s in the header section it
seems that it is not selecting a record but is writing the values “Out of†or
“In to†in to random records.
I’m I am correct in the above then I think I need some way to select the
record (found in the IF statement).
Thank you for any help!!