Text box problem -- wants data upon opening of the form

[RSW]

I figured out the answer to my own question as I was typing it! Problem with the query--unneeded "F_Form!Value"s

 

[rainman89]

do you have a button that executes the query?

if you dont the subform is probably looking for those entries on load.

 

[RSW]

Sigh, I was wrong. What I did stopped the error messages. It also completely stopped my form from working.

Does anyone know of an example online in which entry fields and a subform are blank until info is entered and a "Submit" button is clicked? If I just have an example, I can figure it out from there. I checked my Access training materials, but all their forms start with info already in the text boxes.

Thanks in advance!

 

[rainman89]

set the visible property of the subform to no until the click of the submit button. that way they cant see the info until they enter the data into the text boxes and click submit

 

[GaryPanic]

on the on click of your submit button have
in code
textbox=" whatever text you want"

should do it

 

[RSW]

set the visible property of the subform to no until the click of the submit button. that way they cant see the info until they enter the data into the text boxes and click submit

I suspect that will get me back to the original problem--that the query will want values in those text boxes even though there are none yet--but I will try this now.

(that problem happened even when I set the text boxes to null or * default values)

 

[rainman89]

this could be caused by the record source of the form being the query.
can you post your query? or even a stripped down version of ur db?

 

[Wiz47]

I suspect that will get me back to the original problem--that the query will want values in those text boxes even though there are none yet--but I will try this now.

(that problem happened even when I set the text boxes to null or * default values)

There shouldn't be a request for data until you click the command button and run the query for the subform. That is, if you based the record source on a table and not a query. Otherwise ...

Do as rainman89 said:

set the visible property of the subform to no until the click of the submit button. that way they cant see the info until they enter the data into the text boxes and click submit

 

[RSW]

this could be caused by the record source of the form being the query.
can you post your query? or even a stripped down version of ur db?

Current query is

SELECT USER_DATALOG_MRSI505B_LOG.SUB_NAME, USER_DATALOG_MRSI505B_LOG.SUBSTRATE_ID, USER_DATALOG_MRSI505B_LOG.DIE_NAME, USER_DATALOG_MRSI505B_LOG.DIE_BATCHID, USER_DATALOG_MRSI505B_LOG.PLACEMENT_COMMENT, T_CompLookUp.Reference_Designator
FROM USER_DATALOG_MRSI505B_LOG LEFT JOIN T_CompLookUp ON (USER_DATALOG_MRSI505B_LOG.MULTIUP_X = T_CompLookUp.Multi_Number_1) AND (USER_DATALOG_MRSI505B_LOG.MULTIUP_Y = T_CompLookUp.Multi_Number_2) AND (USER_DATALOG_MRSI505B_LOG.PLACEMENT_NO = T_CompLookUp.Placement) AND (USER_DATALOG_MRSI505B_LOG.DIE_NAME = T_CompLookUp.Part_Number)
WHERE (((USER_DATALOG_MRSI505B_LOG.DIE_NAME) Like [Component_Part_Number]) AND ((USER_DATALOG_MRSI505B_LOG.DIE_BATCHID) Like [Trace_Ability_Data]) AND ((T_CompLookUp.Reference_Designator) Like [RD]));

Subform necessarily needs to be based on a query, as I'm pulling from two different tables.

Opening the main form causes Access to pop up boxes asking what the values in the WHERE clause are. I don't want that to happen.

For those interested, this is for a database that, when component information is listed, will display information relating to that component and where it has been used.

This seemingly would be much easier with combo boxes instead of text boxes, but the number of different components makes that infeasible.

Thanks for all of your help so far.