Re: Inspections and Treatments

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Fred,

My initial thought to your question is... Why would you need to display a
Customer's address in a comboBox? Further, a particular "work" related
record would logically only occur at ONE location, therefore, there wouldn't
be a need to display many addresses (as in "filling" a comboBox with items).

Perhaps I am misunderstanding your requirement here.

Also: I have since expanded this db model a bit to take into account that a
particular customer address could very well be different from the address of
a work item. For example, in my particular model, while the customer calling
to request service might be the owner of a particular residence (the address
for the work to be done), they might not actually live there (perhaps it is a
rental property).

j

"Fred" wrote:

Tina,

Thank you again. I read all of those that you recommended (plus
ControlSource) and experimented with them, and it was very informative.
I'm still stuck at the same place, albiet with greater knowledge. Using
JamesFreddyC's inquiry as an example, let's say that the record source for a
form is tblWork, and we desire to show the address of the customer that the
work was for. I think that you said that a combo box is good way to do this.


I found the BoundColumn and ControlSource help files confusing, I think it
was because I couldn't find the "needle" of what these basically are in the
general-case "haystack" of the help text.

But all of those properties seem to just set what show when the user is
actively using the dropdown arrow....I can get that to work fine. My
problem is how to control what shows when nobody is doing anything with the
combo box. The ControlSource property seems to determine this. However,
it has a dropdown list which is just the fields of the RecordSource of the
Form, and I can't get it to take anything related to the related table that
is the source of the combo box.

E.G. so how would one make the address of the customer show in the combo box
when nobody is clicking on the combo box?

Thanks Again.

Sincerely,


Fred



.

Relevant Pages

  • Re: Combo box action
    ... recordsource query. ... > Likely your problem is that the combobox is bound. ... >> form is a combobox for the customer ID. ... >> names is displayed in the combo box and the address fields are display ...
    (microsoft.public.access.forms)
  • Re: How do I get a combo box to show an initial value?
    ... A combobox will not display a value if the value is not in its bound column ... (regardless of bound to controlsource) ... Alter the combobox rowsource so it does have the value. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Description Field
    ... the source of your ComboBox list. ... possible entries in the second table "additional charges". ... In my Main Order form I need to record which customer placed the order and this ... To *DISPLAY* a piece of data I would have unbound TextBoxes that just pull the ...
    (microsoft.public.access.gettingstarted)
  • Re: How do I automatically populate fields?
    ... > How can I auto populate other fields in my form, ... look them up and display them. ... That way if the customer's address changes in the Customer ... the ComboBox all the additional fields from the Customer table that you need the ...
    (microsoft.public.access.forms)
  • RE: Subform linked to combo box
    ... Let me guess - You set the .ControlSource of the comboBox to a field in the ... Delete out the value of the .ControlSource. ... User selects a customer from a combo box and the subform shows all their ... the new customer to the first order showing in the subform. ...
    (microsoft.public.access.modulesdaovba)