Combo Box Selections

[Karan]

Hi,

I have two tables called BILL and PAYMENT.

when a payment for a particular bill is received, i want a combo box in
payment table to be to select the bill no. from BILL table ( Created using
the Lookup Wizard in Table).

For Example: Bill No. 1; Bill Amount is US$ 3.00

In PAYMENT table If i select the Bill no.1, i want the bill amount in the
next field BILL AMOUNT to be automatically updated with the Value US$ 3.00.

Can this be done !? hope you'll can help me, thanks in advance.

BILL table has following fields:
BILL ID (data type: AutoNumber)
CUSTOMER (data type: Text)
BILL NUMBER (data type: Number)
BILL DATE (data type: Date/Time)
BILL AMOUNT (data type: Currency)

PAYMENT table has the following fields:
PAYMENT ID (data type: AutoNumber)
CUSTOMER (data type: Text)
PAYMENT METHOD (data type: Created Lookup wizard, combo Box: Cheque, Cash,
Credit Card, etc.)
PAYMENT REFERENCE NUMBER: (WANT TO CREATE COMBO BOX FROM TABLE BILL, THIS
WILL BE THE BILL NUMBER, AGAINST THE PAYMENT MADE)
BILL AMOUNT (THIS VALUE OF BILL AMOUNT SHOULD AUTOMATICALLY APPEAR, ONCE WE
SELECT THE BILL NO.)
PAYMENT AMOUNT (data type: Currency)
BALANCE AMOUNT (Once i am through the above i can create the formula in
Query BALANCE AMOUNT: [Bill Amount]-[Payment Amount]

karan.

 

[Ken Snell]

I posted the following reply to your original 4/10 post with the same
question:

See The Access Web for how to do this:
http://www.mvps.org/access/forms/frm0028.htm

Did it not work for you?

 

[Karan]

Mr. Ken Snell,

Thanks for your replies, i didn't get the first reply.

And i tried to put the function in the first Combo box After Update Event.
I didn't assign any Row Source to Second Combo Box. It doesn't work. Any
other suggestion.

Thanks

Karan

I posted the following reply to your original 4/10 post with the same
question:

See The Access Web for how to do this:
http://www.mvps.org/access/forms/frm0028.htm

Did it not work for you?
--
Ken Snell
<MS ACCESS MVP>

Hi,

I have two tables called BILL and PAYMENT.

when a payment for a particular bill is received, i want a combo box in
payment table to be to select the bill no. from BILL table ( Created using
the Lookup Wizard in Table).

For Example: Bill No. 1; Bill Amount is US$ 3.00

In PAYMENT table If i select the Bill no.1, i want the bill amount in the
next field BILL AMOUNT to be automatically updated with the Value US$ 3.00.

Can this be done !? hope you'll can help me, thanks in advance.

BILL table has following fields:
BILL ID (data type: AutoNumber)
CUSTOMER (data type: Text)
BILL NUMBER (data type: Number)
BILL DATE (data type: Date/Time)
BILL AMOUNT (data type: Currency)

PAYMENT table has the following fields:
PAYMENT ID (data type: AutoNumber)
CUSTOMER (data type: Text)
PAYMENT METHOD (data type: Created Lookup wizard, combo Box: Cheque, Cash,
Credit Card, etc.)
PAYMENT REFERENCE NUMBER: (WANT TO CREATE COMBO BOX FROM TABLE BILL, THIS
WILL BE THE BILL NUMBER, AGAINST THE PAYMENT MADE)
BILL AMOUNT (THIS VALUE OF BILL AMOUNT SHOULD AUTOMATICALLY APPEAR, ONCE WE
SELECT THE BILL NO.)
PAYMENT AMOUNT (data type: Currency)
BALANCE AMOUNT (Once i am through the above i can create the formula in
Query BALANCE AMOUNT: [Bill Amount]-[Payment Amount]

karan.

 

[Ken Snell]

Please describe the steps you took to "put the function in the first Combo
box After Update Event". If you tried pasting the function in the textbox
next to the After Update event label in the Properties window, then, no,
that will not work. The code must go into the module that is "behind" the
form. Post back with info re: what you did and then we'll see how to modify
it so that you can be successful.

I also am not sure about "I didn't assign any Row Source to Second Combo
Box". Without a row source, there will be no data in the combo box's
dropdown list, nor can the combo box be "filtered". Is it a typo when you
say "I didn't" instead of "It didn't"?

--
Ken Snell
<MS ACCESS MVP>

Mr. Ken Snell,

Thanks for your replies, i didn't get the first reply.

And i tried to put the function in the first Combo box After Update Event.
I didn't assign any Row Source to Second Combo Box. It doesn't work. Any
other suggestion.

Thanks

Karan

I posted the following reply to your original 4/10 post with the same
question:

See The Access Web for how to do this:
http://www.mvps.org/access/forms/frm0028.htm

Did it not work for you?
--
Ken Snell
<MS ACCESS MVP>

Hi,

I have two tables called BILL and PAYMENT.

when a payment for a particular bill is received, i want a combo box in
payment table to be to select the bill no. from BILL table ( Created using
the Lookup Wizard in Table).

For Example: Bill No. 1; Bill Amount is US$ 3.00

In PAYMENT table If i select the Bill no.1, i want the bill amount in the
next field BILL AMOUNT to be automatically updated with the Value US$ 3.00.

Can this be done !? hope you'll can help me, thanks in advance.

BILL table has following fields:
BILL ID (data type: AutoNumber)
CUSTOMER (data type: Text)
BILL NUMBER (data type: Number)
BILL DATE (data type: Date/Time)
BILL AMOUNT (data type: Currency)

PAYMENT table has the following fields:
PAYMENT ID (data type: AutoNumber)
CUSTOMER (data type: Text)
PAYMENT METHOD (data type: Created Lookup wizard, combo Box: Cheque, Cash,
Credit Card, etc.)
PAYMENT REFERENCE NUMBER: (WANT TO CREATE COMBO BOX FROM TABLE BILL, THIS
WILL BE THE BILL NUMBER, AGAINST THE PAYMENT MADE)
BILL AMOUNT (THIS VALUE OF BILL AMOUNT SHOULD AUTOMATICALLY APPEAR,

ONCE
WE

SELECT THE BILL NO.)
PAYMENT AMOUNT (data type: Currency)
BALANCE AMOUNT (Once i am through the above i can create the formula in
Query BALANCE AMOUNT: [Bill Amount]-[Payment Amount]

karan.