Quick Query Question

[dfwcomputer]

Just a quick question.

is better to use a query for a form or just link straight to table.

e.g you have tblColour, this table has ColourID & Colour.should you build a query including all fields then build a form from that query?

Thanks

 

[Ian Mac]

Simple answer:

A QUERY!!!!!

NEVER link to the table, ever, I can't stress enough.

I'm going to go a bit further on this and possibly upset some people, I wouldn't bind a form to a table or query in most cases.
I generally query a record from a main table to a client side TEMP table and use that as the record for the form.
a) when you are working on the record, you never get locking errors
b) if you make a mistake just exit the thing, as you dont have either THE record or an updatable query of the record the user can't mess it up if they just close everything.

Does that make sense??

 

[dfwcomputer]

yes, thankyou very much.

Dean