Search results

Change record source for command buttons WooHoo! :eek:figgered it out: Private Sub UpdateSignIn_Click() On Error GoTo UpdateSignIn_Click_Err DoCmd.RunCommand acCmdRefresh DoCmd.OpenQuery "SignInOrderSort", acViewNormal, acEdit DoCmd.Close Form.RecordSource = "SignInOrderSort"...

Yep well the answer was simple (thought of it myself!). The record source for the form is the 1st query. So now I have to code the button(s) so they change the record source. Input appreciated. Mods, is there a required number of posts to add my sig?: Guess this stuff is for more...

The event runs (the query opens and closes) but the results do not show in the form. :banghead: jeds

Each button runs a query and I have got the first button to display the query results in the bottom of the split form. Private Sub UpdateSignIn_Click() On Error GoTo UpdateSignIn_Click_Err DoCmd.RunCommand acCmdRefresh DoCmd.OpenQuery "SignInOrderSort", acViewNormal, acEdit...

OK, I would like to understand the reasoning behind this one. I have read this elsewhere, but as a newbie the explanation did not sink in. To explain what I *think* I understand at this point: Lookup fields are Lookup and Relationship fields where you type in the fields you want available in...

pbalby, I believe they are action queries thus my answer, thanks. They are update and append queries. plog, they all work. pr2-eugin, I think pbaldy's answer is why they aren't available in either case. Thanks to all for the speedy reply.

1st post, read the "how to post" stickies...ok, breezed through them. I currently have 4 saved queries. When I start a select query, or use the query wizard, only my table are available. Asking for future reference, I simply expect that at some point I am going to need to "query a query"...

Guess you could say I'm an amateur at Access. I have been self-teaching for a couple of months, got interested as I am a member of the local volunteer fire department where we store a lot of data and many times it is done repetively. Decided to join the forum as I have ended up here many times...