Recent content by noodnutt

Hi Pat I appreciate you spelling out the differences. I have bookmarked this for future reference. Thanks again Mark.

Hi I managed to find a workaround; this works as expected without issue. strCriteria = "lnLocNo = " & Nz(Me.lnLocNo, 0) DoCmd.OpenForm "fDcust", WhereCondition:=strCriteria, WindowMode:=acDialog I have this behind the "Go To" cmdBtn on the "Search" Form, whereas the "Main Menu" cmdBtn just...

Hi @MarkK Thank you for your help. Awesome workaround. I will throw both ideas at it and see which runs smoother. Watch this space. Regards Namesake Edit: Just out of curiosity, I get an error on GoToID.?? Am I meant to replace this with my record field.??

Hi @The_Doc_Man I appreciate your prompt response: Your latter assumption is correct. "fDcust" needs to open with two different Statements/Arguments. 1. Accessing via the "Main Menu" opens to a new record 2. Accessing via the "Search Enquiry" opens to the selected record.

Hi Guys I have two command Buttons on two different forms that access the same form "fDcust" One command button (On the Main Menu Form) One Command Button on the (Search Enquiry Form) The Main Menu CmdBtn is as follows: Private Sub lBtnEdit_Click() DoCmd.OpenForm "fDcust", , , , ...

Hi Team. First time poster here who is dreadful with SQL. Apologies in advance if I do not explain or lay this out correctly. TIA for any help you can throw my way. Although, I get a result! It's not the result I'm after. SELECT PickDate, txHandle, Bulk, Primary, TotalLines, PickHours...