Recent content by doss

Thanks Pat. I'll have to keep that in mind so I don't cause more work for myself......

No problem. Hopefully that works out for you. Much better than doing the "button" thing.

Me.NameUnbound1 = Forms!FormName!ComboBoxHeading.column(2) Me.NameUnbound2= Forms!FormName!ComboBoxHeading.column(3) Me.NameUnbound3 = Forms!FormName!ComboBoxHeading.column(4) This is what is going in the AfterUpdate of the combo box field.

Yes, with me.txtname being the name of the unbound textboxes and the column corresponding the the position of the field in the combo box query grid. I start with column 2 because in my example, the autoID is column(0), and the Product Number or whatever is column(1). So you would end up with...

I'm assuming that you just want the infomation from the combo box viewed on the form and that you aren't needing to save it to any table.... I am going to post a db, I hope you can open it up. Basically, you have the combo box with all the fields you want to view, you have the column count...

What exactly is the button supposed to do?

Okay, I've attached a database. I tried it both with the field as a text field and also as a date/time field and it didn't seem to make any difference. That bit of code should work for you..... Compare with your database and see what's different. Make sure the name of the field you are...

Oooops. Sorry Chris. Guess I should have double checked that before posting. I'll try to look at that here in a little bit.... If anyone else has any ideas in the meantime.....

On the OnClick event of the button you could have something like Me.txtdate = Date() I think that should do it....

Pat, Thanks for your response. I think he's got it under control now.......

Pat, It's actually a little more complicated than that I think. He sent me the database yesterday right before I had to leave work, so I haven't really had any time to look at it. I took a brief peek this morning and there is a problem with structure/relationships. He's got primary keys set...

Hello. You can make a copy of your backend, and put it on your desktop and name it so that you know it's the testing copy. Then open up the copy of the front end where it shows the database window. Go to tools and select Linked Table Manager. Check the box for prompt for new location and check...

Yes, you can email it to me.....but I warn you, no garuntees that I can fix your problem..... :) That's why I was hoping you would be able to post it so that everyone would have a chance to look at it. Better chance of you getting your problem solved... You might make a copy and then delete...

Can you zip your database and post it here?

Create a query with your fields from you table. Under the field for the checkbox where is says "Criteria" type True to show items checked or False to show items not checked. Use this query as the source for your report. There is alot of information on setting criteria for queries in the MS Help...