using bound form

[Roy Goldhammer]

Hello there

I have form which is bound to query contains many tables. and the tables are
being updated for the form.

In the form there are some data that should be shown on the form and not be
updated.


there are 3 ways i know to do it:
1. add the tables of the require fields to query and show them.

2. use dlookup on the control source of the text boxes in the form and bring
the data.

3. open recordset for each one of them and bring it on form load.

The option selected before is 2. and the form is loaded very slow (10
seconds when the network isn't busy)

which is the best way to do that?

 

[Douglas J. Steele]

You can lock the text boxes so that it's not possible to update the content
of those particular fields.

 

[Roy Goldhammer]

Whell Douglas

You haven't understand my question: i'm asking what is the fastest way to
bring this data?

 

[Douglas J. Steele]

I'd say that the fields should be in the recordsource for the form, with the
text boxes for those specific fields locked. That sounds like your Option 1.
Option 2 is definitely going to be slow.

Depending on the data (since you haven't really given enough details),
another option might be to put that additional data on a subform, and lock
the subform. In that way, the additional data would be its own recordset.