Recent content by Reggaefloww

The error is occuring on a Microsoft Access database where Microsoft Access is both the front end and back end. The tables in the Microsoft Access front end is being relinked every time the front end is opening. However, the specified library it is referring to is the name of the database...

I see, lol It looks like I'll have to owe you lunch or something. Thanks very much.

I currently have the following code: For Each ctl In Me.Controls If ((ctl.Name = "PurchaseOrderNum") Or (ctl.Name = "ID")) Then ctl.Locked = True End If Next ctl For some reason, I'm getting a Microsoft Access runtime 438 error. It occurs at the ctl.Locked...

Thanks very much MajP

I actually have the form working exactly the way I want it now, except for one problem. I have my code the exact opposite of how I want it. I want the user to choose the columns they want and show only those columns that have been selected. Right now I'm hiding the columns they selected, and...

Tried that already :). Not sure why it's not working.

How would it work for all controls regardless if they're textboxs or not?

I already tried that lol. :)

Hi guys, I need help hiding all subform controls when a form opens Thanks

I guess I should start a new post lol, since you did solve the original problem.

That didn't seem to work for me.

Thanks MajP Each solution solved the problem. It was a great help. How would you hide all the subform columns when you opened the main form? As you'll notice, I also gave you a star:).

LOL....never mind. Very helpful. Thanks

Thanks MajP for your quick response, but what's blnHide?

Opps, this is my first post to this forum. I created the post as a programmer instead of as a technical user:).