Re: Combo Box

From: tina (nospam_at_address.com)
Date: 04/23/04


Date: Fri, 23 Apr 2004 06:37:25 GMT

i don't think anyone can tell you more than we all already have. it's
probably a simple mistake you're making and there is just a miscommunication
between you and "us". if you want to send me a copy of your db, i'll try to
find and fix the problem, then send it back so you can see what i did. if
you want to go this route, do the following:

make a copy of your db.
remove proprietary data from the *copy*.
add a few appropriate "dummy" records for me to work with.
*compact the database*
zip to under 1MB (if necessary, delete forms/reports/tables that don't
interact with the tables/form you're working on, to meet the size
requirement).
refer to the GettingStarted newsgroup in the email subject line.
copy/paste the posted thread so i'll remember what this is about.
email to ttacc_kill_all_spam_ess1 at _my_yahoo dot com, removing
the underscores and everything between them.

"Dolphinv4" <anonymous@discussions.microsoft.com> wrote in message
news:323901c428e7$f83907a0$a001280a@phx.gbl...
> Hi,
>
> what I wanted to do is actually very simple but I don't
> know why I can't seem to do it in Access.
>
> I just wanted to have a drop down list showing different
> choices that user can choose, ie, Mr, Ms, Mdm, Sir. In
> Excel, this can be done thru the command "Date
> Validation".
>
> But when I tried to do it in Access, I create a combo
> box, and i ONLY amend ROWSOURCETYPE to Value List and the
> ROWSOURCE to Mr;Ms;Mdm;Sir (note that I left
> CONTROLSOURCE empty). When I switch back to Form View, I
> have the correct combo box with the correct list of
> Mr,Ms,Mdm,Sir. But when I choose Mr for record 1, the
> other records in my database shows Mr also. I do not want
> this to happen. I want the user to be able to choose
> different salutations for different records.
>
> How do I salvage this situation?
>
> Thanks so much for all your help so far.
>
> Regards,
> Val
>
>
>
> >-----Original Message-----
> >"Marc" <mPAMpaisl@optusnet.com.au> wrote in message
> >news:40879306$0$25661$afc38c87@news.optusnet.com.au...
> >>
> >> "Dolphinv4" <anonymous@discussions.microsoft.com>
> wrote in message
> >> news:292701c4283c$c548fc20$a501280a@phx.gbl...
> >> > This is getting more n more confusing...Marc, do you
> mean
> >> > whether when I look at the records, it shows a single
> >> > record or many records? If this is the case, I am
> looking
> >> > at a single record per view.
> >
> >If you are saying that you make a selection in the
> ComboBox and then as you
> >navigate to different records you see that same
> selection no matter what
> >record you look at then the ComboBox is NOT bound.
> There is simply no
> >other explanation that I can think of for that behavior.
> >
> >
> >--
> >I don't check the Email account attached
> >to this message. Send instead to...
> >RBrandt at Hunter dot com
> >
> >
> >.
> >



Relevant Pages

  • Re: Cor..
    ... in the database. ... The user select a carmake in the datacombo1 ... Then you do a normal select on your database again with a selection of ... > Carmake is then selected using a datareader from database (Combobox) ...
    (microsoft.public.dotnet.general)
  • Re: Combo Box
    ... and i ONLY amend ROWSOURCETYPE to Value List and the ... other records in my database shows Mr also. ... >If you are saying that you make a selection in the ... >record you look at then the ComboBox is NOT bound. ...
    (microsoft.public.access.gettingstarted)
  • Re: Drop Down Combo Box
    ... I'm populating a combobox with 150 items. ... database. ... The selection from this combo box is used to drive other ... I've created rows with controls. ...
    (microsoft.public.vb.controls)
  • RE: Data table function - A dropdown list replacement for VLookup.
    ... To do this you would be well served by a UserForm which we will create now. ... This will create a ComboBox control on the form. ... “Typing in the selection box will bring matching choices, ... The above code that we just pasted into the code window will take the data ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Data table function - A dropdown list replacement for VLookup.
    ... To do this you would be well served by a UserForm which we will create now. ... This will create a ComboBox control on the form. ... “Typing in the selection box will bring matching choices, ... Private Sub Clear_Form_Click ...
    (microsoft.public.excel.worksheet.functions)