Forum Discussion

Copper Contributor

Mar 23, 2021

List Box anomaly

I have a multi-user Access application -- each user has a client piece locally, all looking at a single Access database with the table data on a company network. A form on that client application (l...

access

RichNewman

Copper Contributor

Mar 23, 2021

George_Hepworth

Thanks for the prompt reply. Here is the code, but it's really amazingly simple..

Private Sub Command6_Click()
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmContractAdd"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

George_Hepworth

Silver Contributor

Mar 23, 2021

RichNewman

Also, what happens in that second form, "frmContractAdd"? Is it adding a new contract to the table which is also the row source for this list box, by any chance?