Search results

I was still getting that error, so I just talked to Microsoft about this - This message may show up if you have a form that contains many Sub Forms. I had a Main form with 12 tabs - each tab had at least one sub form some had 3 or 4. I pulled all the sub forms out of there and it works fine now.

Never mind Never mind - dumb question - I figured it out

how do I take a query that retruns x number of records and populate a table with those records?

Thanks for the replies - I actually had a few dim 'dbs as database' and 'dim rs as recordset'lines, but didnt destroy them :rolleyes: So I just made one global dbs as database and made sure to destroy all recordsets at the end of procedures. Everything works great now - thanks

so, is there a limit as to how many lookups you can have on a form? I use queries to populate combo's and lists - is that what you mean?

When I click on combo boxes on certain forms, I get a microsoft error: "Cannot open any more databases." I've never seen this message before. I am only linked to one database. Anyone ever seen this? What can I check?

Thanks - I did a previous search on the subject, but somehow missed a couple good posts!

Is it possible to use an array as a parameter for a query? I have a list that I want a User to select more than one item and run a query based on the selected rows.

if you have a report come up in 'preview' mode, there is an error if there isnt a printer hooked up to the computer. How can you get around this?

Thanks for your help Drew

How would you write the code to go through a List box, pull out all the indexes from selected rows(multi-select) and do an update query on each record?

Thanks Rich

If I am using a few forms that are popup/modal, how can I preview a report where it shows the report on top instead of having to close down all the modal forms on the screen? Is there some sort of 'Set to Front' action?

Awesome.....thanks R.

is there a way to automatically expand a combo box when it has focus set to it when using the tab button?