Changing to a record based on text box entry

[ali37]

Hey guys, im going to try and describe my problem as best as i can. i have a database with a large number of records. Navigating through the records through a form one by one is a pain, so i want to create a text box where you can enter the ID number of the record, and whichever record has the matching ID number it changes to that specific record. I know that something like this is already apparent at the bottom of Access, but i want my user to do everything within the database itself, as all of the panes are removed whilst being used. Any help would be great thanks

 

[pr2-eugin]

You can use DoCmd.FindRecord. Or if you are using A2007+ then you can use the ComboBox wizard to go to a record.

 

[bob fitz]

You can use the wizard to create a combo box that will do what you require.

 

[ali37]

thanks for the quick replies. im very new when it comes to using VBA as ive only done afew things involving menial tasks with it, could you help me out abit in terms of what lines i should go down for the coding? also, this search text-box will be on every record to make it easier to navigate around. Not sure whether or not thats important

 

[ali37]

bob fitz how would i go about creating the combo box like that?

 

[pr2-eugin]

You need to look at using ComboBoxes, as suggested by me and Bob.. That is so much easier, it will not involve coding from your end the Wizard takes care of it..

 

[ali37]

ok, ive created the combo box using the ID's from the respective records. so how do i edit it so that, once changed, it will automatically change the record to the one with the ID matching the combo box choice?

 

[pr2-eugin]

Okay I think I have the functionality confused with something.. I just tried to use the ComboBox to search for a Record. It's not available. Hmmm... Not sure, well a good explanation could be found at Allen Browne's site. Or even Support article from Microsoft.

 

[ali37]

Thanks guys, Allen Brownes site has been really useful and using that ive sorted the combo box out to do what i want it to, cheers

 

[pr2-eugin]

Glad you have it sorted. Good Luck.

 

[ct2013]

Hi there,

I find the combo box bugged every so often and doesnt always work, so i therefore made a query with a criteria on the ID [place ID no.] and that way it just pulls that one up.

it is lovely to use!

If anyone has any idea why when i creat a form combo to select records in that table it seems not to work unless i go into design view and then back out then it works but as soon as i close the form i have the same story.

Many thanks

 

[pr2-eugin]

Hello ct2013, I am unable to understand your problem. Could you please start a new thread describing your problem, so other can help you as well?