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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DSum() usage for calculated textbox on a continious form 4
Total on a continious form 2
Creating a continious sub form 2
Form.Detail DO or DONT allow edits to the controls (text boxes) 2
Hiding record - continious form 2
Continious forms 1
help with continious forms 5
Errors with Sub Form Totals 4

Back
Top