look up ID in a form

A

Angeline

Hi, my knowledge of access is fairly basic but have managed to build a form
off a table using the wizards and gratefully searching these posts for
explicits steps.

I have a form that will be used by about 3 or 4 people, there are about 40
records (IDs) currently in the database and I have set up buttons to allow
the user to go to the next record. Now that the number of records is getting
bigger, I'd like to be able to search on the ID field and select the record I
want to go to. So if it ID: 20, i don't have to click on my arrow button 20
times to get to it. I know that this can probably be done with a list box or
combo box but just not entirely sure how these work so would love a bit of
(step by step) guidance in this area if possible. Thanks so much.
 
A

Angeline

Hi Gina,
Thank for your help that worked like a dream. The only thing I am noticed
now however is whenver I open this form it seems to take a long time. I also
received an error on opening the database which said something like 'you have
used the review option and the database has to 'group' results, this may take
a long time do you wish to continue' upon which I clicked yes and the
database didn't respond. I ran a repair and seems okay now but the actual
form I have put the look up combo box on is still taking along time to open.
Could this be why?
 
G

Gina Whipp

Angeline,

Adding a combo box to a form should not cause it to load slowly, unless of
course you have thousands of records in which case that MIGHT be the issue
but still I have not seen that happen.

1. What version of Access?
2. Since I have never seen or heard of the 'review option' where and what
is that?
3. Exactly, how many records are in the database? Is it just the 40 or so
records?
4. Are you running an Antivirus and is it scanning *.mdb's or *.accb's
5. How many fields are in your table or query that your form is based on?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
T

tina

you can use an unbound combobox control to "find" a record and go to it. or
you can create a custom shortcut (pop-up) menu with the familiar
"binoculars" icon on it, to search the ID field, or any visible field in the
form, for the value you want to go to.

hth
 
A

Angeline

Hi Gina,
1. 2007
2. I'm sorry I can get the message back.
3. Only 40 records
4. No anti-virus software
5. There are only about 20 fields on my table.

Seems a little strange. when I opened up the database it ran an auto-repair
so seems okay now. Thanks so much for your help!
 
A

Angeline

Hi Gina,

I think the problem may be that I split the database so the table is sitting
in the back end. The lookup combo box has to continually reference the table
linked from another database so maybe this is why things are slow? The entire
design of the form is very slow and not sure if it is the share drive or
access itself.

Thanks very much for your assistance though :)
 
G

Gina Whipp

Angeline,

Using linked tables does not slow a database down THAT slow. What is the
path to the linked database and what kind of network is it on? Also, where
is the front portion of the database?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 

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

New computer, how do i move outlook 365 ENTIRELY? 0
Copy previous record into form field 0
How to create skip pattern in access 2013 form 0
Can't figure this out 7
Trying to do a Mouse over Effect in Visio 0
Help Building Complex Data Entry Forms – PART 1 3
Combo Box Look up 1
Avoiding Duplicate Entries 4

Top