Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. beenut23

    open form, populate textbox

    This was the solution: Private Sub cmdOpenDispo_Click() Dim stDocName As String stDocName = "frmDispoForm" DoCmd.OpenForm stDocName, , , , acFormAdd Forms!frmDispoForm!txtCaseID = Me.txtCaseID End Sub that way it opens to a new record with the specific CaseID I wanted. thanks!
  2. beenut23

    open form, populate textbox

    hello! I have a button on a form, which when clicked, opens another form. The code for my button is: Private Sub cmdOpenDispo_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmDispoForm" stLinkCriteria = "CaseID=" & Me.txtCaseID...
  3. beenut23

    Can I have Sum NOT in the footer?

    Hello good people. Could someone kindly tell me if I can have a textbox with a sum of other textboxes in it, and NOT have my sum in the footer of the report? I have a textbox with the following control source, and it always is empty? =Nz([txtTime1]+[txtTime2]) Both txtTime1 and txtTime2 have...
  4. beenut23

    nested if to check both main form and subform

    The form this is on is a form which holds name information in the main part of the form, and then the address, ssn, and dob is in the subform. It has to be this way for a variety of reasons. At any rate, if I am understanding you correctly, if the user changes the ssn accidentally, which is on...
  5. beenut23

    nested if to check both main form and subform

    Hello. I ave a form on which I must check if the user has changed anything on both the form and the subform. my nested if statement is wrong, I can tell, because it doesn't work at all. Before I added the two blue lines, it was fine if changes were on the form, but didn't check the subform...
  6. beenut23

    need help adding new record to subform

    Hello, thank you for your reply. no, this still overwrites the existing record on the subform. This is so wierd. why won't it write a NEW record to my subform? very very confused.
  7. beenut23

    need help adding new record to subform

    Hello PHV. thank you kindly for your reply. Trying your suggestion, but unfortunately it still does not add the new witness to a new record on the frmAddNewCase.subfrmCaseWitnesses but instead overwrites whichever record on that subform the cursor was on when the user clicks the add new...
  8. beenut23

    need help adding new record to subform

    Hello. I am having trouble getting my code to add a new record to a subform. Here is the situation. I have a main form frmAddNewCase, which has a subform on it subfrmCaseWitnesses. When the user clicks the button they first see a msgbox asking them if they want to search for a name first...

Part and Inventory Search

Back
Top