Search results

Thanks Lister. It helped me figure out I had my subform query looking at the wrong field. For what I wanted to do, I needed the query to be looking at the Data Entry field, and I had it looking at the list box field. It's rockin' now!!! I always appreciate the help!! :D :p :D :p

Hello All, I have a form/subform question. I have a mainform with a field that I want people to enter up to a 10 digit number (PO numbers), to find info in the subform (in datasheet view) in realtime, i.e. when I type "1" in the search field, my subform lists all the records with PO numbers...

Hello all, I have a main form with many subforms and I am looking for help with saving the data via buttons. I have 3 custom buttons on the main form: Previous Record, Next Record, and Save Record. I am looking for the best way to prompt a person, if they have made any changes any field in...

Wildcard Search Too I have a similar problem to this. I would like to do the same (a real-time search), but update the results in a query that is a subform. The search field, named [SearchBox] is on the main form, and the Query is named qryRimSheet. The field I am trying to search by is a text...

I found this to resolve my same problem with this error. In my form, I had a text box with this formula : =([Forms]![frmReportOptions]![StartDate]) that was generating the error when I tried to export the report to Excel. I removed the "=" and the parentheses around the formula and it...