4 replies
by eschlangen
by trainer4063
Poster rated this answer.
by trainer4063
Unfortunately, I also need to edit the information in the CustomerTableA or B. A union query will not allow me to edit or change the information in it. A union query is read only. I have a form that allows me to manually make the link, I'm trying to automate the selection based on a field in the SalesTable so my users don't have to stop what they are doing just to change which table they are getting their information from. The forms VB code to make the selection looks like this:
Private Sub cmdAttachTable_Click()
If MsgBos ("Attach table " & Forms!frmAttachTable!Attach & "?") Then
DoCmd.DeleteObject acTable, "Campaign"
Docmd.TransferDatabase acLink, "ODBC", ............
DoCmd.Close
End If
End Sub
I just want to automate the process for my users. The less they have to interface with the better.
by trainer4063
This discussion is closed to new replies.
Trending Software posts
Sort by Trending