By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,124 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Access Dynamic Find

P: 3
I am trying to make my drop down name field automatically go to the record selected in that field...is this possible in access 2000? and how do I do it....findrecord?
let me know and thanks
Nov 3 '08 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
Create a form based on your table or query, including all the fields you want displayed. Then simply:

Add a combo box to your form. The Combobox Wizard will pop up

Select "Find a record based on the value I selected in my combobox."

From the query or table the form is based on, click on the field you're searching by (it needs to be a field whose value will be unique for any given record) to move it to the right side.

Hit Next.

Size the column appropriately.

Hit Next.

Name the combobox.

Hit Finish.

Now you can drop the combobox down and scroll down to the item to search by, or you can start to enter the item, and the combobox will "autofill" as you type. Hit <Enter> and the record will be retrieved.

Welome to Bytes!

Linq ;0)>
Nov 3 '08 #2

P: 3
WELL..i ALREADY HAVE A FORM MADE UP...AND THERE IS A DATASHEET IN IT THAT SHOWS THE RECORDS FOR THE CUSTOMER...I HAVE A NAME COMBO BOX WITH A ROW SOURCE ALREADY...AND THERE IS 85 CUSTOMERS ALREADY IN THE TABLE...WHAT i WANT IS WHEN I OPEN MY FORM..IT DYSPLAYS A RECORD...AND WHEN I CHOOSE THE NAME IN THE LIST I WANT THE FORM TO DYSPLAY THAT RECORD...SORTA LIKE WHEN A BAR CODE READER READS THE CODE AND GOES TO THAT RECORD...I HAVE BASED MY FORM DIRECTLY ON THE TABLE..NO QUERY...SO IT WILL SHOW ALL RECORDS...JUST IF I SELECT A NAME FROM THE LIST IT ONLY REPLACES THE NAME FOR THAT RECORD...DOES NOT AUTOMATICALLY GO TO THE RECORD ASSOCIATED WITH THE NAME i HAVE COOSEN...YOU GET MY DRIFT...HOPE SO..AND THANKS AGAIN
LET ME KNOW IF YOU CAN HELP
Nov 3 '08 #3

P: 3
ok..thanks have it working...just had to make it unbound...thanks again...great forum
Nov 3 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.