J
Jeff
Q1: I have two forms based on a single table. One to
input new customer records that goes directly to a new
record and does not allow editing of existing records.
This form works great. The other form for updating
customer records and allows for editing of existing
records. I want to use a new form to pull up the entire
record based on user input of the customer ID.
I want the new form to have one field named CustID, and
two buttons. One for selecting the appropriate record
based on the CustID input (using a drop-down menu from the
original table, if possible), and one for canceling and
going back to the main switchboard.
Q2: Below is the code for one of my update forms. I have
set things up so that my main switchboard and other forms
all open maximized. How can I have it so that when the
update button is clicked, the main switchboard is closed
and the update form is maximized, and then when the update
form is closed, the main switchboard opens maximized?
Private Sub UpdateExistingCust_Click()
On Error GoTo Err_UpdateExistingCust_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "CustDetailsTableInputFormUPDATE"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Maximize
Exit_UpdateExistingCust_Click:
Exit Sub
Err_UpdateExistingCust_Click:
MsgBox Err.Description
Resume Exit_UpdateExistingCust_Click
End Sub
input new customer records that goes directly to a new
record and does not allow editing of existing records.
This form works great. The other form for updating
customer records and allows for editing of existing
records. I want to use a new form to pull up the entire
record based on user input of the customer ID.
I want the new form to have one field named CustID, and
two buttons. One for selecting the appropriate record
based on the CustID input (using a drop-down menu from the
original table, if possible), and one for canceling and
going back to the main switchboard.
Q2: Below is the code for one of my update forms. I have
set things up so that my main switchboard and other forms
all open maximized. How can I have it so that when the
update button is clicked, the main switchboard is closed
and the update form is maximized, and then when the update
form is closed, the main switchboard opens maximized?
Private Sub UpdateExistingCust_Click()
On Error GoTo Err_UpdateExistingCust_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "CustDetailsTableInputFormUPDATE"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Maximize
Exit_UpdateExistingCust_Click:
Exit Sub
Err_UpdateExistingCust_Click:
MsgBox Err.Description
Resume Exit_UpdateExistingCust_Click
End Sub