Search results

I had a feeling it wasn't possible. I could try something like what you mentioned, but it may not be what the users wanted. Thanks for your help!

Hello all. I'm trying to create a Find function in a report. I have a textbox and a command button labeled "Find." I want to type something in to the textbox, such as "Company," and click the Find button. I want it to search the whole report for the next instance of "Company." Also, I want...

Sorry, I am not receiving an error message. It's just not filtering. I did check the name of the subform control vs. the name of the subform, but that isn't the issue.

I'm still having trouble with this. Does anybody have any suggestions?

Beetle, thanks for the help, but unfortunately that didn't work. Any other thoughts?

Hi everyone. I am trying to filter a subform when I open the parent form from a different form with an option group. So, the first form pops up with the options: 1) Show "Active" Contracts 2) Show All Contracts. If the user selects 1, I want it to open the specific customer form...

Just a quick follow-up question: Will it not work if the form has a subform? I actually have a couple nested subforms. It's form>subform1>subform2>subform3. Subform2 and subform3 have navigation buttons, but the "On Current" code doesn't work for Subform2.

That worked. Thanks! :D

I'm trying to disable command buttons if I'm at the first or last record. So, for example, If I'm at the very first record on a form, I want the Previous and First navigation buttons to be disabled. I'm not having any luck with EOF and BOF. I've also tried using AbsolutePosition and...

Okay, this is a dumb question: On your DB, when I click "Find Port," FRM_FindPort shows up not maximized (ie restored), but FRM_Country stays maximized. I cannot get my form to do this. (By the way, this is in a completely different form than before). It either maximizes both, or...

Now it seems to be working. I was getting an error before, but this time it's fine. Thanks!

Okay, for some reason, my code seems to be working now. I swear I tried this before: Private Sub btnOpenItem_Click() DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenForm "frmContractForm", , , "CustomerID=" & Me.CustomerID End Sub Thanks for the help!

Yes, I tried both the main form and subform. Here is what I have for the main form: Private Sub Form_Current() 'Enable Contract Changes if Active Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "SetMe" Then ctl.Enabled = (Me!frmAmendmentSub.Form.Status = "Active")...

I tried that, but it didn't work.:confused:

@pbaldy: The code works for After Update, but not for On Load. I tried it for when the main form loads, and when the subform loads. (The subform is where Status is located). Here is my code: Private Sub Form_Load() 'Enable Contract Changes if Active Dim ctl As Control For Each ctl In...

@Simon_MT: Is there a better way to save it than DoCmd.RunCommand acCmdSaveRecord? @PNGBill: When I requery, it opens a different record. Here is my code: DoCmd.RunCommand acCmdSaveRecord Me.Requery DoCmd.OpenForm "frmContractForm", , , "CustomerID=" & Me.CustomerID Thanks!

I'm doing this in another form now, but I'm still having trouble. Here is my code: 'Open Open Item form DoCmd.OpenForm "frmOpenItemsForm", , , "ContractID=" & Me.ContractID 'Find correct record Forms!frmOpenItemsForm!frmOpenItemsSub.Form.OpenID.SetFocus DoCmd.FindRecord...

Hello everyone, I'm trying to open one form from another. The problem is, from the first form, frmCustomer, I am creating a new record. When I click the button, the new form, frmContractsForm, opens, but to a new record. Since the parent form of frmContractsForm, I want it to open based on...

Hello, I'm trying to open a form to a specific subform (from a completely different form). From frmOpenItems, I'm trying to open frmContractForm with the matching CustomerID and its subform, frmContractSub with the matching ContractID. Here is my code, but it's giving me an error: Private Sub...

Thanks, this information will come in handy. And your user name made my coworkers' and my day :cool: