Getting Values From Forms/Subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have this code:
'This will check to see if the job has been released by List Maint. to
production, if not then then job cannot be processed
strLMReleased = "SELECT [TrackNo VALIDATE tbl].TrackNoValid, [TrackNo
VALIDATE tbl].LSTReleaseDate " & _
"FROM [TrackNo VALIDATE tbl] " & _
"WHERE [TrackNo VALIDATE tbl].TrackNoValid = " &
[Forms]![frmListReleaseTrack]![ListRelease Track tbl
sbfrm].Form![TrackNoValid] & ";"


I am entering data in the TrackNoValid field and it's not reading it, Could
anyone help?
 
No. You enter the value on the subform itself.

Douglas J. Steele said:
Do you get a popup-up asking for a value, or not?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Anna said:
Hi,
I have this code:
'This will check to see if the job has been released by List Maint. to
production, if not then then job cannot be processed
strLMReleased = "SELECT [TrackNo VALIDATE tbl].TrackNoValid, [TrackNo
VALIDATE tbl].LSTReleaseDate " & _
"FROM [TrackNo VALIDATE tbl] " & _
"WHERE [TrackNo VALIDATE tbl].TrackNoValid = " &
[Forms]![frmListReleaseTrack]![ListRelease Track tbl
sbfrm].Form![TrackNoValid] & ";"


I am entering data in the TrackNoValid field and it's not reading it,
Could
anyone help?
Click to expand...
Click to expand...
 
Sorry, I was thinking that you were running the SQL with the field reference
in it: whether or not you got a popup would indicate that whether or not
Access recognized the reference to the field as being value. Re-reading your
post, though, it's obvious you're not doing that.

Where is the code snippet: on the subform, on the parent form, or on another
unrelated form? What is [TrackNoValid]: a text box, or some other control?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Anna said:
No. You enter the value on the subform itself.

Douglas J. Steele said:
Do you get a popup-up asking for a value, or not?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Anna said:
Hi,
I have this code:
'This will check to see if the job has been released by List Maint.
to
production, if not then then job cannot be processed
strLMReleased = "SELECT [TrackNo VALIDATE tbl].TrackNoValid, [TrackNo
VALIDATE tbl].LSTReleaseDate " & _
"FROM [TrackNo VALIDATE tbl] " & _
"WHERE [TrackNo VALIDATE tbl].TrackNoValid = " &
[Forms]![frmListReleaseTrack]![ListRelease Track tbl
sbfrm].Form![TrackNoValid] & ";"


I am entering data in the TrackNoValid field and it's not reading it,
Could
anyone help?
Click to expand...
Click to expand...
Click to expand...
 
TextNoValid it is a text box on the subform. For some reason the mask is all
zeroes and it can read that, but when you type a number in which is a
requirement, it doesn't recognize it. In properties it's also listed on the
the control source and in expression builder it's connected to the field in
the table.

Douglas J. Steele said:
Sorry, I was thinking that you were running the SQL with the field reference
in it: whether or not you got a popup would indicate that whether or not
Access recognized the reference to the field as being value. Re-reading your
post, though, it's obvious you're not doing that.

Where is the code snippet: on the subform, on the parent form, or on another
unrelated form? What is [TrackNoValid]: a text box, or some other control?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Anna said:
No. You enter the value on the subform itself.

Douglas J. Steele said:
Do you get a popup-up asking for a value, or not?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Hi,
I have this code:
'This will check to see if the job has been released by List Maint.
to
production, if not then then job cannot be processed
strLMReleased = "SELECT [TrackNo VALIDATE tbl].TrackNoValid, [TrackNo
VALIDATE tbl].LSTReleaseDate " & _
"FROM [TrackNo VALIDATE tbl] " & _
"WHERE [TrackNo VALIDATE tbl].TrackNoValid = " &
[Forms]![frmListReleaseTrack]![ListRelease Track tbl
sbfrm].Form![TrackNoValid] & ";"


I am entering data in the TrackNoValid field and it's not reading it,
Could
anyone help?
Click to expand...
Click to expand...
Click to expand...
 
If I'm reading you correctly, you have a text box TextNoValid on the form,
which is bound to a field TextNoValid in the underlying recordset. Sometimes
it helps to rename the field to something different from the field. I always
rename all of my text boxes so that their names start with txt, like
txtTextNoValid.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Anna said:
TextNoValid it is a text box on the subform. For some reason the mask is
all
zeroes and it can read that, but when you type a number in which is a
requirement, it doesn't recognize it. In properties it's also listed on
the
the control source and in expression builder it's connected to the field
in
the table.

Douglas J. Steele said:
Sorry, I was thinking that you were running the SQL with the field
reference
in it: whether or not you got a popup would indicate that whether or not
Access recognized the reference to the field as being value. Re-reading
your
post, though, it's obvious you're not doing that.

Where is the code snippet: on the subform, on the parent form, or on
another
unrelated form? What is [TrackNoValid]: a text box, or some other
control?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Anna said:
No. You enter the value on the subform itself.

:

Do you get a popup-up asking for a value, or not?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Hi,
I have this code:
'This will check to see if the job has been released by List
Maint.
to
production, if not then then job cannot be processed
strLMReleased = "SELECT [TrackNo VALIDATE tbl].TrackNoValid,
[TrackNo
VALIDATE tbl].LSTReleaseDate " & _
"FROM [TrackNo VALIDATE tbl] " & _
"WHERE [TrackNo VALIDATE tbl].TrackNoValid = " &
[Forms]![frmListReleaseTrack]![ListRelease Track tbl
sbfrm].Form![TrackNoValid] & ";"


I am entering data in the TrackNoValid field and it's not reading
it,
Could
anyone help?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top