New to Forms-Display a blank combobox but have one column in it restricted to a combobox?

Hi Norie

Originally Posted by Norie

You want the user to pick an invoice no from a blank combobox then have all the clients invoices displayed?

Almost. What I had in mind was this: A blank combo box (2 visible columns, say 1 row) would be displayed on the 2nd page of a multiform. If the user clicks in the first visible column in the combobox, a dropdown of current outstanding invoices would appear (similar to a dropdown list in Excel when you click in the entry cell). The user will then select an invoice. User tabs to the 2nd visible column and enters a currency. Upon selecting this cell, the combobox automatically expands to add another row so that the user can then assign a 2nd invoice and amount. And so on. (Yes the last bits weren't described in the OP, I was going to break it down into individual problems).

Originally Posted by Norie

Why aren't they picking the client from a non-blank combobox?

They will be. The code for picking the client is on the first page of the multiform and this will be a combobox with a list of current debtors (code is working for this).

Originally Posted by Norie

As for a combobox within a combobox, I can't see that happening, why not have a separate listbox that lists the invoice numbers based on what the user has selected in the combobox?

Well I could but then how would the end user breakup the total against individual invoices?