Re: Find customer by customernumber using sql ?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Spookie,
The query behind the combo box allows the user to select a unique
CustomerID for Access to find.
The AfterUpdate code of the combo performs that Find.

Private Sub cboFindRecordID_AfterUpdate()
DoCmd.GoToControl "RecordID"
DoCmd.FindRecord cboFindRecordID
DoCmd.GoToControl "LastName"
End Sub

If the Combo control you placed on your form doesn't show a RowSource
property, then make sure that you have the ALL tab selected in the
Properties box, and look again.
If it's still not there, then it's not a Combobox. All Combos and
ListBoxes have a RowSource, where a table, query, or value list determines
what choices will be displayed to the user for selection.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"SpookiePower" <boxjunk2600@xxxxxxxxx> wrote in message
news:1140010485.707497.61260@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm a bit confused about how you do this. I can see that you have
something called
"Row Source" in the combobox containing a query. I cant see who this
query connect to the two textboxes and then, when I place a
combobox/textbox on my form, there is not something called "Row Source"
where I can put a query.



.

Relevant Pages

  • Re: populate
    ... Just enter the names of the tables or queries as the Row Source for the ... As for creating the query to be used for the CityD combobox's row ... the Row Source property of the CityID combobox. ... using the Country as the criteria. ...
    (microsoft.public.access.gettingstarted)
  • Re: populate
    ... > source, as per my earlier example, I would recommend using the query ... > the Row Source property of the CityID combobox. ... > Steve Schapel, Microsoft Access MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: Query/Lookup Problem
    ... A combobox has two sources of data: ... Row Source Type to be set to: ... getting the List from a table like your Names Table using a query like your ... So you would have: PersonID, Name, Crew returned ...
    (microsoft.public.access.gettingstarted)
  • Re: Basing one combo box on a query result and auto fill a second
    ... Row Source Type Table/ Query ... Since there is only one feature for each ... second combobox is working and displaying the balloon #s correctly, ...
    (microsoft.public.access.forms)
  • Re: Limiting a Combo with an other Combo
    ... In Combo Pièce, I noticed that the Row Source query is returning 3 fields ... the bound field for each combobox is the ID field returned by the ... Row Source is being stored in Pièces.Oeuvre from the form's Record Source ...
    (microsoft.public.access.forms)