event

[mdcory]

I have a form that is populated via an append query with 28 new records that have different sample names entered into the SampleName field. I need to have "-----" entered in to some of the fields depending on what the sample name is. I would like this done automaticlly when the form is opened, everyway that I have done it (form_oncurrent, form_load...) I have to click each record to get it to run that bit of code to put those in. I have pasted what I have in the code now. Please keep in mind that I am very very new to VB and there is probably mistake after mistake in the code, and any suggestions would be greatly appreciated. I hope everyone can understand what I am saying, I find things like this very hard to explain and make sense to anyone.
Thanks,
Matt

I put it in a text file it told me I had to many characters...

 

[Rich]

You don't need code, use the query to append these values

 

[mdcory]

Thanks for the reply, I thought more about it after I posted and thought about that soultion too.
Thanks again,
Matthew