Billing System Form

[INTELLIGEE]

I hope someone can help me to make my form look like the attached system. It's been awhile since I've used access so i'm so closed yet so far in solving my case. I want a the bill amt, payout amt, e/a , vendor name to show up everytime I chose a bill code in my drop-down list. My concept is shown in the attached photo. How am i about to do that & what controls shall i use? Thank you!

 

[catalin.petrut]

You can't expect people to respond to this. You need to share the level that your db is at.

 

[INTELLIGEE]

I have posted my level of knowledge from the new user's forum. I didn't know i have to post that info everytime i open a post. But if you insist, like i've mentioned from my first post, im fairly new to access 2007 but been a proficient user of the older version and used this program long time ago that's why i'm seeking help.

 

[catalin.petrut]

You level of Access knowledge is important, but i've asked about your database level. How is it structured, how many tables you have and things like this.

 

[way2bord]

Without further details this is going to be very bare bones -- To imitate the picture, Try:

New Form >
Form > Default View: Continuous form


Header:
3x command buttons at top: Save, Reimport, Exit
4x labels: Code/Desc, Amount, Payable/Vend..., Income...

>> combo box filled with bill codes.

Details:
8x text box
Code..., Amount, Payable/Vend, Income...
Code Desc., 2x Payable/Vend..., Income/Payable...


Footer:

7x text boxes for Summation of values