Need a Suggestion on a Solution

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:
I have a table set up of over 3000 books where I want to create a
combo box or textbox to search the table and auto fill the other text boxes.
I have the auto fill part down from another lesson however when I make the
combo box and link it to the table, the computer just hangs.

If I go to test it in Form mode, and click the down arrow the computer
queries this field for about 30 min, no exaggeration.

I need help with a solution that will work just like northwind but with a
ton more product.

Any advice would be great.

Paul
 
Paul

You create a new form in design mode. You select the combo box tool and
follow the wizard through to identify which table holds the book info. You
save the designed form and open it. When you click the drop-down, it runs
for 30 minutes.

Did I paraphrase your situation correctly?

Which version of Access? Split front-end/back-end or all in one .mdb file?
Does this only happen on the one Access database, or on every one?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi Jeff,
Thanks for your help. Yes you paraphrased that correct. For your
questions

Version of Access is 2003

All in One mdb file

This does not happen with the customer drop down which has 500 customers in
it.

Also, attached to the drop down with the ISBN's I have this VB code - don't
know if this will help you or not..

Private Sub IsbnNo_AfterUpdate()
If Not IsNull(Me!IsbnNo) Then
Me!BookTitle = Me!CustomerName.Column(9)
Me!PerPrice = Me!CustomerName.Column(10)
End Sub

Thanks again for your help,

Paul
 
Paul

I'm at a loss. What happens if you start over, and leave the extra code
out?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi Jeff:
Well I got it working, what I did was started over and made a new
query of the books and started with one col. then went on to 2 and 3 columns.
It is working now so I guess I should have not let access make the query of
the books and made it from scratch.

thanks for your help,

Paul
 
Back
Top