data edit (entry) through a continious form

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi everybody,

I'm using a continious form with textboxes/comboboxes
linked directly to a table for data editing.

Please, advise whether it's a correct way to do this.

Thanks
 
Whether you use a continuous form or single form it does not matter. As far
as connecting directly to the table is really not a big issue. Some
developers create queries against the tables and use the query to attach to
a form. The advantage to this is if you want to sort your data in a
particular order other than with the tables primary key you can because you
are using a query.

2000 and above:
Having said this, you can still execute a query against a form built using
the table. While you are under the design view of the form, you can invoke
the SQL Query Builder by clicking on the ellipses button against the
RecordSource. This will save a SQL string within the confines of the form
and not create a separate query file.
 
Back
Top