Recent content by mattstewart

Hmm, I just tested this and it worked. I made a form with a tab control and put a txtbox (named txtNameID) in the first tab with the control source being [Name_ID] (whcih is from the table the form is based off of. Then in the second tab page i made a control box with the control source set...

you can use the expression builder to set the control source of a text box (or combo/list or other such objects) to a feild in a different table other than the one the form is based off of.

Is your form in Data Entry mode? Check in the forms properties, if data entry mode is yes, then your form will only display new records after it is closed. change it to no and it should display the data in the table it is based off of.

Just make a macro, with Maximize as the action. Then put the macro in the OnOpen event of the form. This will maximize the window when the form opens.

I have two text boxes on a form. The first one, sbfQualCardID i have some code behind the on change event. What i want to happen is whenever the value in that feild changes, i want the the 2nd box (mnfQualCardID) to have the same value. The first box gets its data from a subform. The control...

Thanks Pat! That worked great

I need to be able to make a module that can paste the results from my query (qryNumbOfGroups in Trending.mdb) to an excel spreadsheet (FunctsAndIssues.xls). or would this be easier to make a macro in excel that gets the data from access. I just don't even know where to start with this. any...