dlookup performance issues

G

Guest

I'm not sure how to solve this.

My problem is that I have to display some data in a subform. This is some
info that can be updated elsewhere, but needs to be current on this form.

It is 33 values wide by 4 high. So a total of 132 fields. The data is
coming from a table that has 33 records in it. So I'm basically displaying
an entire table's worth of data horizontally across the form. Doing it in a
datasheet subform will not work.

Dlookup is terribly slow to do the recalc.

I need to either be able to recalc individual controls, or find better way
to display the data.

Thanks
 
S

strive4peace

Hi Nathan,

why can you not do it with a subform?

an alternative way to show related data is this:

make a combobox whose controlSource comes from a field in the
RecordSource of your form (or is sinmply set since you know what you
want to show) and whose RowSource is the related table. The combobox
can be hidden but should have all the columns you want to display.

The, you can use calculated fields to show information

controlSource --> = combobox_controlname.column(1)

this will be the second column since column indexing starts at 0

Another way would be to open a recordset behind the form and write the
values with code


Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
J

John W. Vinson

I'm not sure how to solve this.

My problem is that I have to display some data in a subform. This is some
info that can be updated elsewhere, but needs to be current on this form.

It is 33 values wide by 4 high. So a total of 132 fields. The data is
coming from a table that has 33 records in it. So I'm basically displaying
an entire table's worth of data horizontally across the form. Doing it in a
datasheet subform will not work.

Dlookup is terribly slow to do the recalc.

I need to either be able to recalc individual controls, or find better way
to display the data.

Thanks

In addition to Crystal's suggestions - can you use a Crosstab query to rotate
the data horizontally?

John W. Vinson [MVP]
 

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

Top