Search results

Thanks, splitting the database worked.

I have an Access 2003 database on a server at work. The server's operating system is NT4 SP 6A. We typically have about 5 to 7 people at one time accessing the database. Records are not locked. We recently hired a temp to enter information into the database. The database crashed and has...

That's what I was looking for... Thanks!!! That worked! :)

I forgot to mention that the form record source that I'm trying to change is in an unbound subform based on a query. In the main form, I have combo boxes providing the criteria for a query on the subform's query. I would like to change the recordsource of the subform to reflect this new query...

I have a form that is based on a query. I would like to change the form's RecordSource to another query using SetValue in a Macro. Under Action Arguments I have Item: Forms![Receiving Query subform].RecordSource But I don't know what to put for an expression. I would like to use the same...