Recent content by cpc101

:) It does the same thing mine does... The default class is selected on opening and that is the only class that will show even after you pick another class... If I change the default value to "" It will select the apropriate class when selected however, If I should make a mistake and select...

Example A... Ooops... I moved it to B. Now I don't get the error, but if I select a different class Item in the option group, It does not refresh the displayed data in the 'Item' Combo box. Private Sub Class_AfterUpdate() Me.Class.Requery End Sub The data entry folks should use arrow keys...

GREAT!!! Now it does what I want! However, I dont think that I have the afterupdate configured correctly. I entered the =Me.Class.Requery statement but am still getting an error about macros. I followed the instruction listed above.

Ok so this is waht I have in my Combo Box... SELECT [Item Master.Class], WHERE [Item Master.Class]=[Forms]![Tag Entry All Locations]![Class]; I get the following error: Syntax Error (missing operator) in query expression 'WHERE [Item Master.Class]=[Forms]![Tag Entry All Locations]![Class]...

Getting "Me" is an invalid macro or doesn't exist error....

Please excuse my ignorance... I've only been working with Access for a few days now... :) I'm not really sure where to enter the items you have listed... Here is what I have: Table: Classes Fields: Class and Class Names Class Field contains records: Numbered 1 thru 8 Class Names Field...

Option Group Headaches..Please Assist Hello... As a Network Administrator unwittingly thrust into the world of Access, I am running into the following dilema... I have a form that is to be used for Data entry for our upcoming inventory. The form contains: Count Tag Number: Entered by user...