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....findrecor d?
let me know and thanks
let me know and thanks
-
-
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)> -
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 HELPComment
-
ok..thanks have it working...just had to make it unbound...thank s again...great forumComment
Comment