Table navigation using a combobox

[robinsdale]

Hi, I'm a VFP programmer (with a FoxPro DOS background) - I'm looking for a way to find a record using a combobox. The
combobox could be populated with a SELECT or whatever. The other fields on the form would display information of the found record, and would also display a listbox with records of a child table related to that record, i.e.:
Parent table - patients
Child table - visits

I've checked the FAQ and browsed the forum for the past few hours, and the closest to an answer I'v egotten was a hint by Rick Sprague where he hinted in his answer that he had a technique, but that it was fairly long. (Thread181-75270)
My first question is: is this a poor way to find a record? Is there an upper limit of how many entries you want to have in a combobox in Access?
If not, then: is there a designed way to do this, or does one have to resort to VBA to move the record pointer - archaic way of saying "find the record"... :
Thanks for answering...
Robin

 

[mymou]

Hi

If you want to find a record - using a form - then can't you use EDIT | FIND or RECORDS | FILTER?

Stew

 

[robinsdale]

I guess I left that part out - I wanted an alternative to what I considered a bit of an awkward solution: the dialog box. In my VFP apps, the user can choose a specific record easily using the combobox as a navigation tool. I was curious to why MS Access didn't seem to provide this capability in the properties sheet (unless the ControlSource can actually be used for that) or was I missing something?
You see, the form was going to have a combobox to navigate to the record of a specific patient, and then simultaneously do a SELECT of all visits that patient had to display in a list box. Making a choice from the list box would then move the record pointer in the procedures table, and display information about that particular procedure. A dialog box would be terribly awkward to invoke for each of the 3 searches.
There must be a straightforward way to do this, I should think...

Thanks awfully for any ideas.
Robin

 

[robinsdale]

Ok, think I found the answer in the Northwind example, specifically the Orders form. It seems to do what I want, which is navigate through a table using the combobox entry to move the record pointer.
Sorry to have bothered y'all... :

Robin