Recent content by HGoodloe

dhookom, I just solved my problem. In the BeforeUpdate code that you provided, right below Cancel = True I added Undo. Private Sub Code_Number_BeforeUpdate(Cancel As Integer) If Form.NewRecord Then If Not IsNull(DLookup("code_Number", "County_Rec", "Code_Number=" &...

Yes, I do want to reject any duplicate numbers in which the BeforeUpdate code you provided on yesterday does exactly that. With the BeforeUpdate code you provided, when I enter a number that is a duplicate, I then hit the tab button in which the message box appears, and that’s what I want...

Sorry to bother you again. The BeforeUpdate code is still working just fine. However, when the message box pops up when there’s a duplicate, if I should click the refresh button to regain access to the combo box, instead of refreshing, the duplicates message continues to appear. I use a...

Ok, that code worked. Thanks very much dhookom

Table name is County_Rec, Fields are Code_Number(don't want duplicates), Grant_Document, Mortgage_Type and Sales_Type. The same field names are on the form. Thanks

I have a form with some text boxes and one of them is for a Code Number (number datatype). The form also contains an Add New Record button. I’m trying to code the Code Number field to reject any duplicate numbers. Yes, I’m aware that there’s an option in the field table properties that will...

Hello, this should be my last question for a while. I have a form with some text boxes and one of them is for a Code Number (number datatype). The form also contains an Add New Record button. I’m trying to code the Code Number field to reject any duplicate numbers. Yes, I’m aware that...

Ok, I understand. In fact in one of my past projects I did put a close button on the main form to close the subform. This time around I wanted to try closing the subform with a close button on it. But, I'm beginning to see that that is probably not possible. For this project, I went ahead and...

Yes, I tried visible = false, but it didn't work. The click event for the close button on the subform doesn't include a visible or invisible option for the main form.

Ok, in the On Load even of the master form I have the subform set to visible = false and that works just fine. However, when both the master form and subform are opened, when necessary, using the closed event button, I would like to only close the subform without it also closing the master...

Hello, I’m working with a master form and subform. I have a closed button on the subform, because at times I want to only close or exit out of the subform while the master form remains opened. The problem I’m running into is that when I click the closed button on the subform, it also closes...

Darrylles, just read your last thread. Sure, I can share the code that solved my record search issue. If there's a master form containing a text box used to search a record in the subform, include the following code in the click event. That code links the Master Form to the Subform...

Darrylles, I totally understand that the sub-form should never display sub records that are not related to Main form records, therefore the Main form and sub-form records were and are related. I worked on the forms some more after returning to work this morning and finally got everything...

Hello Darrylles, Yes, I have a Master form with a child sub-form. And yes, the sub-form contains many records, however when I type a contract number in the record search text-box on the master form, I only want whatever record that is associated with a particular contract number to be...

Yes, I'm working with a subform. The code I presented in my first thread on this website worked just fine with my other projects including show all records, but for whatever reason isn't working with this current one. I guess I'm a bit confused myself with what I'm trying to accomplish here. I...