Problem with duplicate record button

[lccrews]

I've attached a sample of my database that has the problematic button. If you open it and go to frm_itemmaster and search 'test' it'll bring up the test record. I set a button called 'item change' to duplicate the current record so that the user can make changes. I created the button using the wizard. I'm not sure why, but I keep getting error 'recordsgotonew' isn't available. I've double checked that the query is updateable and that you can add records. So far I've checked the following attributes: Allow Additions (Y/N-tried both), Data Entry (Y/N-tried both), Record Locks (No Locks). When Data Entry is set to YES, I can no longer filter records. So hopefully that isn't the answer. Can anyone tell me what I'm doing wrong?

[June7]

Why form/subform? Why not the subform as a standalone with buttons in form header section? What I did:

1. cut/paste buttons to header section of subform

2. remove dynamic filter from query (I never use them)

3. set RecordSelector property to yes

4. change the ControlSource and Name properties of Item No textbox to just Item No

5. open the subform as independent form

6. run the Item Change code


Advise no spaces nor punctuation/special characters (underscore only exception) in naming convention. Better would be: ItemNo or Item_No, IsEmbossed or Is_Embossed, Temp_Cel, NonGMO_Just

[lccrews]

Thank you June7. I wasn't sure why I couldn't filter anymore but I added the dynamic filter back to the query and everything works as expected. Thanks again!

[June7]

I would apply criteria to form Filter property. Put the dynamic parameter back if you prefer. Since you use wildcard to pull in all fields, don't want field to display twice so set the second Item No reference used for the filter to not display - uncheck the Show box - and reference the now standalone subform. So first delete the main form and rename the subform.

This copy/paste approach allows duplicate Item No - is that appropriate?

Suggest a combobox for selecting the Item No with RowSource: SELECT [Item No] FROM tbl_ItemMaster;

Can have code in Item No AfterUpdate event instead of a button Click. Use button if you want to offer multi-criteria search capability.

Also, instead of RecordSource reference to a query object, could have SQL statement there.

[lccrews]

June7 as always you are a wealth of knowledge. Thank you again. I do take notes from you.