RE: Setting the value of text field based on 2 combo boxes

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

Thanks Ofer for your help,
I ended using option group instead of combo boxes.
But the problem i am encountering now is that the value 1,2 ,3 shows in the
table instead of the actual value.
for example when i created the paid by option group, i made company=1 to
client=2, and so on.
How do i make company, client show on the table instead of 1 or 2?

"Ofer Cohen" wrote:

Hi fifi

I have to go now, and I wont be around until tomorow if you have no luck,
you can post the mdb to
chamudim <@> hotmail <dot> com

Specify the form name, and I'll check that, if you do, please ZIP the file,
either wise hotmail will reject it

--
Good Luck
BS"D


"fifi" wrote:

My combos don't have any SQL, at least not that I am aware of. I created
using a wizard and I chose the 1rs option ( look up the value from a table).
Maybe that's the problem. Any suggestions.
I am getting desperate

"Ofer Cohen" wrote:

Hi fifi, please post the SQL of the combo's, so we can know to which clumn to
refer to.

--
Good Luck
BS"D


"fifi" wrote:

Thanks for the response,
1. the category company name is category
2. the paidyby combo name is mailbox paid by
3. the category rowsource is the category table which has 4 choices, 1,2,3,
and 4
4. the paiby combo rowsource is the paidby table which has 4 choices also,
client, company, TBD, and other.
Thank you for your help



"Ofer Cohen" wrote:

Hi fifi,
To answer your question please provide us with some details

1. category combo name
2. paidby combo name
3. category combo RowSource
2. paidby combo RowSource

--
Good Luck
BS"D


"fifi" wrote:

hello
I would like to set a value to a text field depending on the value of 2
combo boxes.
for example the combo box1 has category 1,2,3 and 4
combo box 2 has paidby client, company tbd, and other

Now i would like the fee ( which is a plain text field) to display a value
based on the values of the two combo boxes
for example if category =1 and paidby=client then fee =40
if category=1 and paidby=company then fee=30


Your help will be greatly appreciated

.

Relevant Pages

  • Re: One check box or the other
    ... already going to be an option group it may as well be the bound control. ... First, you would need the two check boxes bound to the two controls, ... When a vendor's certificate is due to expire we request an updated ...
    (microsoft.public.access.formscoding)
  • Re: One check box or the other
    ... already going to be an option group it may as well be the bound control. ... First, you would need the two check boxes bound to the two controls, ... When a vendor's certificate is due to expire we request an updated ...
    (microsoft.public.access.formscoding)
  • Re: One check box or the other
    ... First, you would need the two check boxes bound to the two controls, ... Then you need the option group with 2 option buttons. ... suggesting I use an option group to control the hidden check boxes. ... When a vendor's certificate is due to expire we request an updated ...
    (microsoft.public.access.formscoding)
  • Re: Option Group?
    ... You can't do that with an option group, since an the group can have only one ... If you want to proceed with the bitfield, use stand-alone check boxes (not ... Dim btDOW As Byte ... Called by AfterUpdate of all 7 checkboxes ...
    (microsoft.public.access.forms)
  • Re: One check box or the other
    ... suggesting I use an option group to control the hidden check boxes. ... When a vendor's certificate is due to expire we request an updated ...
    (microsoft.public.access.formscoding)