Decomposed > [frmMedia].[Title]
Am I right in thinking that that is a table and field?
Are you sure you shouldn't be using something like ' form2.TextBox1.Text=form1.TextBox1.Text '
to get the data out of the field of your data input form?
http://stackoverflow.com/questions/13578670/how-to-pass-value-of-a-textbox-from-one-form-to-another-form
I'm thinking I may have created a 'hidden text field' on a form, and tucked a string into it. Then VBA was able to access the hidden field (Or was it my query was able to access the hidden field?)
Right, the hidden fields I used were for storing a date selected with a calendar form. And I needed to get the date out of the calendar (on the form) and put it somewhere where my query could read it and give me the appropriate date related data.
I have a memory of wanting to query the shop log, and I wanted to insert three text strings to search the data base for. One to limit the equipment I was searching for, one for the problem field, and one for the solution field.
So I had three fields on the form to input the search criteria. And VBA would take the three variables and search the database for anything that matched all three strings.
Good times.
Zim.
Mad Poet Strikes Again.
| 