Search results

Thanks for the responce, What will that do???? I have never seen that function and I looked it up on the web and still did not really understand what it does. ( I don not have time to try it right now, but will over the weekend) . Thanks.

Tried what you suggested, but that did not work because it bypasses the duplication check on a new entry - Value is what is entered by the user and OldValue for the controls = Null.

I have a subform that collects the following data to put in a record in tblClass: StudentID, Trimester, SubcatID, WorkGrade, SkillGrade Before the record is written for the first time OR edited/updated to the table, I want to search tblClass and determine if the new/updated info will create...

Lets say that the control on the form is a combobox (because you did not specify), in the Form_BeforeUpdate Event try entering something like this: if isnull(cbo) then msgbox "Missing Entry" cbo.setfocus cancel=true Exit Sub end if

I looked at the Bound Column and RowSource in both the sfrm and the Table, but nothing seemed different. I ended up creating the subform from scratch instead of copying it from a similar one and it works fine. Still not sure, but it is working:) Thanks for the help.

The items involved are: tblClass_Writing ==>Table that stores the data from sfrmClass_Writing sfrmClass_Writing ==>SubForm that displays and allows users to add grades frmClass_Writing ==> Form that contains sfrmClass_Writing I am having trouble between the subform and the table. WhenI...