Recent content by PeterM

I have a form. The two fields are [Payment] (a Yes/No tickbox) and [Amount Outstanding] (A currency value). I want Amount Outstanding to change to £0.00 once the uer has selected the Payment tickbox...how would I go about achieving this? The Amount Outstanding Text box in form design view...

Hey. I want to have a form open as soonas I open up the database. It's called ControlForm and it allows me to navigate to other forms. How would I go about setting it up to open as soon as the database file is opened? Thanks!

Anyone able to help on this? I still can't get it working :(

Ok I have had a go and it provides the feature that I want but I'm having problems expanding it. My Example. I want to be able to create an invoice form so that I can choose customer details at the top section. (Already Achieved from CustomerTable). I then want a subform with a way to...

Thanks guys, I will try and implement that stuff tomorrow. The sample database had sort of the feature I want, I'll tweak it tomorrow in my main database but it should work! Thanks for the helpful replies :D

I created a query from a table with 3 fields: CartridgeID (KF) Brand Unit Price I want to be able to create a query where it is possible to have a dropdown list of the CartridgeID's as the first field and then for the correct brand and UnitPrice to be displayed depending on what CartridgeID...