Query and recordsource

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I have a query that prompts for [txb_Name]. On my form is a txb_Name
textbox. and a cmdbutton that sets the forms recordsource to the query.
When I click the command button I am still being prompted. Why?
 
Syntax needs to include FORMS![formname]!txb_Name

Replace formname with your form name.
 
Steve, Thanks for the info.
This works OK but......When the query returns a empty recordset I get an
hourglass for a few seconds and then it exits access. Any ideas?

[MVP] S.Clark said:
Syntax needs to include FORMS![formname]!txb_Name

Replace formname with your form name.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Jeff said:
I have a query that prompts for [txb_Name]. On my form is a txb_Name
textbox. and a cmdbutton that sets the forms recordsource to the query.
When I click the command button I am still being prompted. Why?
Click to expand...
Click to expand...
 
Repair and Compact.first. If it continues, then start troubleshooting doing
things like recreate the query from a new query, add the Nz() function to
prevent nulls, etc.

Jeff said:
Steve, Thanks for the info.
This works OK but......When the query returns a empty recordset I get an
hourglass for a few seconds and then it exits access. Any ideas?

[MVP] S.Clark said:
Syntax needs to include FORMS![formname]!txb_Name

Replace formname with your form name.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Jeff said:
I have a query that prompts for [txb_Name]. On my form is a txb_Name
textbox. and a cmdbutton that sets the forms recordsource to the query.
When I click the command button I am still being prompted. Why?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top