Combobox

[113deluxe]

I have a table with seven coloumns, I`ve made a form with a combo box and 6 textfield, each representing one of the coloumns in the table. the combo box contains all the data in the first coloumn in the table. is there a way wich I can choose a value in the combo box and then view the record for the chosen value??

 

[ColinEssex]

Use the wizard to create the ComboBox.
You'll need option 3 "find a record based on.......etc etc" to get the form to open at the selected record.

Col

 

[113deluxe]

I`ve got the combo box to work but how do I delete a record? If I chose a record from the combo box and want to delete it, how do I do that?? I`ve tried using the button wizard and chosen the delete record but it doesent work, If I delete a record it doesent disapear from the table, it just says Deleted# in the combo box...

 

[dcx693]

It sounds to me like your form needs a small re-design. If you're using the 1 combo box and the 6 text fields to represent the 7 fields in your underlying table, then I'm guessing that all of the 7 controls on your form are "bound". That means that the controlsource of each control is a field in your underlying table.

Nothing wrong with that. It's just that it's a really bad idea to use a control on your form that is directly tied to a table field for anything but inputting or editing data. You don't want to be conducting searches using those "bound" fields also.

My suggestion is to place a "unbound" combo box in the form header and use that only for record searching. Set it up so that when you choose a value from it, it will display the corresponding record on the form. Follow ColinEssex's advice for that.