Search results

this is a bound form. imagine a form that has multiple records, and each record has fields like; name, address, phone number. and rather that going through these fields and deleteing their contents one by one, you just hit a button that deletes their contents? that as opposed to deleting the...

i know that the wizard in a form makes it very easy for you to delete the record you are currently in. however i feel like i have hit a wall in finding a way to clear all data entered in the current record. i do not want to delete the record in question just clear it as if it was new.

seeing as it is a sub form, maybe an on load?

sure, in my previous question i was looking to click on a hyper link to pop up another form that had a value in a matching field to that of the hyperlink clicked. in this new pop up i have yet another form (3rd form) being used as a sub form. this sub form also has the field in it that the first...

alright, i now have another one. very very similar to my first request except instead on on click, i am looking to do on open. this time for a sub form of thefirst form i referenced earlier that i am being directed to from my above onclick command. once again, help is appreciated.

That Did It! Thank You very much! and i appreciate the help from everyone!

in the compile error pop up it is telling me: "Method or data member not found"

i may be fighting a losing battle here. i appreciate all of your help. but i am continuing to get the same problem. in my case the field name and the control name are the same, and i may be confused because i am having trouble picturing a scenario where they will be different...

the thing is, when i enter the debug the private sub line is highlighted yellos, and then on the docmd line, the Me.WOnumber is selected.

also, dtata type for all fields is text

i have done some changing to tables and forms names to remove and spaces of \ and # characters. the below code is located in a form in a text box as an on click event. Private Sub CloseWO_Click() DoCmd.OpenForm "CloseWO", , , "WOnumber = '" & Me.WOnumber & "'" End Sub

sorry, i am unable to do that. something i may be confused on is the sifference between the field name and control name?

alright. i used the second code provided in the Baldy Web page and it brings me to the proper form, and is filiered to a single record. however, it is showing a blank record and not the matching one. I am using: DoCmd.OpenForm "Destination Form", , , "Field Name i wish to Look Up on the...

i continue to experience problems with the coding. specifically with the stLinkCriteria = "[EmployeeWO] ...... part

thank you. i will give this one a try as well. if there are multiple resolutions to my problem i would liove to hear them all as i would like to make sure that i accomplish what i am setting out to do.

i appreciate the response, and the link you gave me looks like it may do the trick, however, the values between the two forms that match are pulled from a table, meaning the matching values in the text boxes are bound. so in the code, rather than telling access to find the matching value of...

I have an odd dilemma on my hands... I have a form in my db, let's call it "staffed employees". on this "staffed employees" form, i have a sub form, let's call that "employees w/o". the "employees w/o" form is designed in data view and one of the rows is a hyperlink (done in form design view...