Relating a combo box with another data from different forms

[stickooo]

Hi,

I created 2 forms ("Bills" and "Payments&quot.
In "Bills" I have 2 boxes: "periods" (ex: june 2002, july 2002, etc) and "total due".

In "Payment" , I want to create a combo box with "periods" (from "Bills" form) lists on it and then shows the related "total due" in the box below it.

Could anyone please tell me how to do it.
I'm just trying to learn MS ACCESS to create a database for my small business. A detail solution is preferable.

thanks
sticko

 

[pgk]

Hi,
Can you be a little more elaborate as to what exactly you want to do? Also, in the Bills form, will the period be entered in a text box?

Post again and we will work out a solution. Cheers.


With regards,
PGK

 

[nberryman]

We need details on tables and any relationships that exist.

It sounds like ma form sub form senario.

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[stickooo]

Hi,

I'll try to be more specific this time. My main form is a "Client" form. In here the client info is entered.
Then there are two command buttons "Bills" and "Payment" where each of them will open up a related form. "Bills" and "Payment" are related with ClientID. Thus every client will have their own Bills and Payment detail.

PGK, I would use combo box for "period" in Bills form.

thank you so much.
Hope you all can help me now

sticko

 

[nberryman]

Try creating a form based on the Clients table with the Form Wizard. After you select the fields change the table to the payment and select the required fields from that table.

The wizard should create a main form and a sub form. When you change the clients on the main form the sub form will show their payment details

-OR-

On your existing form use the command button wizard to Open a Form. One of the wizard steps asks if you want to show all records or specific records. Select Specific records and link the id fields that will then create a button that will open the form linked as you specify

If non of that works let me know



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com