Search results

Thats what the problem was. Thanks alot bob. Everything works fine now.

Still is set to yes. I can still add data and it shows up in the form, but never adds to my main form record view.

The database we use collects information from our volunteers, currently with around 1580 records. Yesterday while inputing data, the main form stopped displaying records. The table and query still show all data, however the form for search/input now shows only 1 record. Ive tried changing...

Thanks for all your help. It gave me a base to start trying different options that finally led to a working parameter on my form. Now, I am having trouble getting multiple parameters to work on one form. There are 4 sets of info on 4 septerate listboxes that I need to pull from, but if I try...

Thanks Ken, I used the parameter you gave, replacing everything after "my" and when I added the equal sign it changed everything to .... [forms]![SubForm]![List0] I changed the name of my subform to SubForm,(easier to remember) and the Listbox is List0. Do I need the brackets? I dont have...

I created a report based on my query, and returned to the query to set the parameters in the criteria. I am following the suggestion that Maxmangion provided, but am getting an error telling me I dont have an operand. Here is the code I put in .... Forms!Agency SubForm!List0 The subform is...

I have a table with 8 categories. I would like to be able to create a subform that will allow me to use listboxes to set the parameters that will be used to generate a report. Is there a way to set this up so that once the parameters have been chosen in each category I can generate the report...

I need to track employee training hours and employee backfill hours. I will need to see which employee was training, and the employee who filled in for him. Both will have the same info. Is there a way to use two tables on one form, and keep the record number the same in each table? I would...

Thanks! That did it.

Thanks PBaldy, thats exactly the case. If I open the report, then the form, it works. Is there a way to work this so I dont have to open the report? Or do I need to set up the report to open in the background when this form opens. I will have two totals from two seperate reports, so it would...

Im trying to have a cost total displayed on my form, but cant get the data to show up. I have calculated total expense in a report, but when I try to pull the data to my text box on the form, I get #Name?.. Do I need to calculate my totals elsewhere, or is there a different code I need to use...