help with combo box

[pwssms]

I have a combo box on my form that is used to pull in information into other fields. Two things.

1 - When I start the form, I want the other fields to be blank.
I have tried to set the data entry to 'no' for the form. This works, but when I change the data or select another data from the combo box, I get an error.

2 - I also have created a report and a command button on my form page that will preview the report. (it's a bar coded identification tag). The problem here is I have 14 records in my table and all 14 of them are trying to print. I only want the one I have selected using my combo box to print. Can anyone help?

Let me know if you need anymore information.

Thanks,
Phillip

 

[aleb]

What do you mean by starting the form with blank fields ... does that mean you want to start the form to enter the new record or you don't want the new record but want to wait till somthing will be selected in lets say combo box ?

in criterion for the record source of your report reference to the selected field on your form smth like on example: