combo

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

I need to bind a selection in a combo box to the rest of a form.
Table: ID,NAME,ADDRESS,CITY,STATE,ZIP - ID is 3 Letters.

I have all fields on a main form. I only want to display, not edit add or
delete. (which I have "NO" in form properties.)
Actually I combined ID and NAME in a combo form. I used SELECT DISTINCROW
customer.ID, customer,NAME
and 2 columns and 0";2" to suppress seeing ID . I only see NAME in the combo
box.

Somewhere I didn't bind (or whatever) the combo box to the main form fields.
I can use the bottom record selectors. The rotate the customers thru the
combo box. But if I try to select manually from the combo box with the down
arrow slider, I select the name but none of the other fields (add, csz )
change on the form.

I don't know what is wrong. Point me towards a sample if it is too hard to
explain.

Also related to combo boxes. Say I only wanted ID in the combo box (AAA,
ABC, etc.) Is there a way I can put in the first letter of the ID and have
it bring to to that part of the alphabet rather than scrolling? Or even
more, take ABC and just take me to the record?

Thanks.
rob
 
rob said:
I need to bind a selection in a combo box to the rest of a form.
Table: ID,NAME,ADDRESS,CITY,STATE,ZIP - ID is 3 Letters.

I have all fields on a main form. I only want to display, not edit add or
delete. (which I have "NO" in form properties.)
Actually I combined ID and NAME in a combo form. I used SELECT DISTINCROW
customer.ID, customer,NAME
and 2 columns and 0";2" to suppress seeing ID . I only see NAME in the combo
box.

Somewhere I didn't bind (or whatever) the combo box to the main form fields.
I can use the bottom record selectors. The rotate the customers thru the
combo box. But if I try to select manually from the combo box with the down
arrow slider, I select the name but none of the other fields (add, csz )
change on the form.

I don't know what is wrong. Point me towards a sample if it is too hard to
explain.

Also related to combo boxes. Say I only wanted ID in the combo box (AAA,
ABC, etc.) Is there a way I can put in the first letter of the ID and have
it bring to to that part of the alphabet rather than scrolling? Or even
more, take ABC and just take me to the record?
Click to expand...


I don't understand what you're trying to do here.

If you want to display the combos other fields on the form,
you can use text boxes with expressions like:
=combo.Column(2)
for the ADDRESS value.

OTOH, if you're trying to get the combo to navigate to a
matching ID, then use its AfterUpdate event:

With Me.RecordsetClone
.FindFirst "ID _ " & Me.combo
If Not .NoMatch Then Me.Bookmark = ,Bookmark
End With

You can get the combo to automatically scroll to the first
entry that matches what's been typed so far by using the
AutoExpand property.
 
I'm getting it but not getting it. I made a small sample with my problem
being quite obvious. I have a Main form called table-company with four
records in combo. Change the record (ID) in the combo but the name and
address don't change. Anyone brave enough to look at, I named it test.mdb.
220 kb.

email me at (e-mail address removed) (obviously take off the nospam.) and
I'll send off a copy. This is the only thing holding up an otherwise pretty
simple project. I must be missing something obvious.
Thanks.
rob
 
rob said:
I'm getting it but not getting it. I made a small sample with my problem
being quite obvious. I have a Main form called table-company with four
records in combo. Change the record (ID) in the combo but the name and
address don't change. Anyone brave enough to look at, I named it test.mdb.
220 kb.

email me at (e-mail address removed) (obviously take off the nospam.) and
I'll send off a copy. This is the only thing holding up an otherwise pretty
simple project. I must be missing something obvious.
Click to expand...


I won't be able to do that. First, I normally get paid a
good fee to fix other people's databases. Second, I'm going
to be out of town until next week.

Either post a new question with a clear explanation of what
you have, what you want to accomplish and the specific
problem that's causing you trouble.

Asking people to fix your problems for you is way beyond the
scope of a discussion group. Occasionally someone will do
it, but don't hold your breath waiting for that to happen.
 
Back
Top