Search results

I'm not sure how to go about doing this as I don't know how to specify these records or relate them to the selection of the comboboxes. Also, when I attempt this it says I need an object name? Sorry, I'm pretty new at this so I'm not sure what to do...

I have a list box with a query as its row source (screenshot attached). The query gets data from my Contracts table with information on a Consultant ID, Contract ID, and a Contract Status indicator. This effectively represents each contract with a specified status. What I'm trying to do is...

Is it possible to make a macro to automate this function? If so, how is this done??? I want to be able to have this function assigned to a button on my database. Thanks in advance for anyone's help/advice.

I want to make a button that will lead the user to another tab (which contains a subform). What is the code required for this? Thanks in advance!

also how can i hide the values typed in under the password textbox (ie: how can I make it so that when a person types in a password, the entry is shown as '*'; ie: '********' as opposed to 'password')

this also might be difficult because I need the command button to set a field equal to a certain value for a particular record

how is that accomplished?

Is it possible to password-protect a command button? In other words, is there a way to require a user to enter a password upon clicking a button, in order for that button to carry out its specified function? The obvious reason behind doing this would be to only allow only certain users to have...

thanks boblarson worked perfectly

what code would you use though. this is what i tried using: If Forms![frmConsultantList].SSN = "" Then Forms![frmConsultantList].FedTaxID.Locked = False Else: Forms![frmConsultantList].FedTaxID.Locked = True End If but after doing that, the locked field does not unlock and...

quick question; how do you lock a particular field after a different field is updated?

i would like to see this done as well

never crossed my mind bob

i actually didn't do this and my database seems to be running fine. do i really need this? i'm afraid with tampering with the structure of the database as im nervous about opening up another can of headaches....

nm...figured it out. i had some what seems to be arbitrary line in my main forms afterupdate event. it seems to work fine now though. you've been a HUGE help boblarson, i can't thank you enough.

wow boblarson ur a lifesaver...i got it working just fine. one error did come up tho; with all the new code and changes implemented, when I go from my main form to my 'Contracts' subform to enter data, i get an error message saying that the macro 'Me.' does not exist. ??? pretty puzzling

...nm again lol. i re-entered your suggestions from before and it seems to work now...at least no parameter request appears.

changed the names, but still problems. when i open my main form, it now requests a parameter for "PrepareName"

....nm got it

sorry if this is a dumb question, but how do i edit container names??