Search results

How do I tell the control source to be what ever is chosen in the Category field. I looked at the control source and it listed the form I've already created. I didn't see how to do anything other than pick a form.

I have a form with a Subform. On the form there is a drop down category field. I want the subform to change depending on the category that is picked. For instance on the form if you pick the category "Vehicle" then the "Vehicle SubForm" displays as the subform. If you pick "Electronics" then the...

Thanks for the info. I downloaded the file now I have to figure out how the heck I incorporate it into my database. Thanks for the help!!!

I have a form that has 5 tabs. Is there a way to change the tab colors? Thanks, Rick

Pat that worked GREAT!!! THANKS!!! Your However paragraph was that geared to me or the first response post? As I said in my original post I'm just trying to learn some of this stuff. There is probably o alot of things I've done that don't make sense.

This is what I put (I put it in the Double Click instead of Click) Private Sub PACCode5_DblClick(Cancel As Integer) Forms!Unassigned Cost Codes Form!PAC5Code.SetFocus Forms!test1!PAC5Code.Text = PACCode5.Text End Sub I get Compile Error Syntax error and the first line (Forms!.......) has...

I have a form with a subform and the subform lists a 5 digit code. I want to be able to click on the 5 digit code in the subform and have that number moved/copied to a field on my main form. Any suggestions? P.S. I'm new to Access so detailed explanations would be greatly appreciated. Thanks...

Is there a way on a report to "autonumber" each line item? On my report depending on my criteria I enter I get different data. I would like each line to be numbered. Plus when I run the report again I want the numbering to start at 1 again. Thanks, Rick