getting correct output

[jalldridge]

Hi guys,

Attached is a real simple database. What I want to be able to do is insert new payment details, and I have a couple of issues.

I have two clients and need to be able to select which client I want, select the payment details from the drop down list and enter in some appropriate amount.

Its been a while since I've created a db from scratch so this is obviously where I am having my difficulties. However I think I need to use a sub form.

How can I input the details as above, and how can I always get the combobox to default to the first entry in the list rather than defaulting to zero?

Thanks for the pointers.

 

[ScottGem]

Use the Combobox wizards to build a combo bound to clientID. Then delete the control currently bound to clientID.

You can set the Default value of a combo to whatever value you want. But the Value must match the BOUND column, not the displayed column.

 

[jalldridge]

Thanks for that. Never used the wizards before. Quite neat.

One thing. The bound colum is set but is there a way to set the index value of the combobox? As the moment its blank and the entries are cash and cheque. Would like index 0 to be the default ie cash

Thanks on this point

 

[ScottGem]

Depends on how you have the combo setup. If you used a value list of simply cash, cheque then set the default value to "cash". If you queried a table and are using the PK as the bound column then set the default to the value of cash's PK.