Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Applying filter query to SubForm problem
Working with subforms can be a little tricky. That's because the main form looks at them as a control. This means you have to jump through a few more hoops. Try this code to set the record source of the subform to the query you have already built. Run this from a button on your main form...- Bobala
- Post #2
- Forum: Microsoft: Access Forms
-
Only Numerical Characters?
Try this. Define your field as text and define your input mask as: !\(###")-"###\-#### This should keep the user from entering anything but numbers. Hope this helps.- Bobala
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Combo box doesn't save values to the Table
Sorry about the lag, I'm just getting back on. I've found that problems like these usually have simple answers. Have you handled errors to keep them from being displayed? If it displays the primary key and not your data the format may be conflicting.- Bobala
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Combo box doesn't save values to the Table
Check under Data in Properties for your combo box. Make sure to have to bound column pointed at the right column. You probably want it set to 2.- Bobala
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
