a few questions

[Jim VanGordon]

I have a "Save" button on the form that also refreshes.
I was wondering if you could throw in a code segment to
disable the save buttons on the toolbar and menu bar.

Also, I have a union query that combines multiple tables
to search through all the tables at once. I need some
way to distinguish which table it came from though. Is
there a way to put another field on the form that shows
the table the information is coming from automatically.

Thanks,
Jim VanGordon

 

[Lynn Trapp]

Place the table names in the select list in quotations:

Select Field1, Field2, Field3, "FirstTableName"
From FirstTable
UNION
Selct Field1, Field2, Field3, "SecondTableName"
From SecondTable

 

[Jim VanGordon]

Thanks for answering one of my questions, Lynn. I was
wondering if any one could help me with the disabling of
the save buttons though. Just didn't want you guys to
forget about the other part. I really appreciate all the
help I've gotten here from the MVPs and everyone else.

Thanks,
Jim

 

[Lynn Trapp]

Create a custom tool bar with the buttons you want on it and attach it to
your form.

 

[Jim VanGordon]

I can't believe I didn't think of that. I was just making
it too difficult.

Thanks,
Jim