Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding A Combo list to a grid 1

Status
Not open for further replies.

cobweb

IS-IT--Management
May 5, 2002
95
GB
Hi there:
I have created an orders database, with a header and detail table. An entry form has the details as a grid.
A third table is products. The cunning plan is to allow the user , when entering a detail line, to select from a drop down list in the grid an item from the products table.
Now I can create a combo that does all that - but I cannot get the combo to 'sit' on every line. Instead it sits over the grid as a single box - not a box per line. I can drag the thing anywhere on the form!
Microsoft Q138779 says "place a combo box in the third column"...but all mine do is sit on it!
Thanks!
 
Click on your grid, then right click on it and select 'Edit'. Drag a combobox control and drop it on the desired column.
In theproperties sheet, select CurrentControl for that column and in the dropdown for that column, select Combo1.
Also, for that coulmn, set the 'Sparse' property to .F.

See if that helps.


-Dave Summers-
[cheers]
Even more Fox stuff at:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top