Recent content by pmkieffe

Thanks for the reply. The objective changed on me. VLOOKUP is all I need now. Thanks, pmkieffe

Hi, Thanks for any help. I am familiar with Excel lookup functions, but I am looking for something more than VLOOKUP and LOOKUP. Lets say I have column A and B on one tab. I have column C and D on another tab. A B C D I would like to search column A for any...

Hi, Thanks for any help. I have a combo box in a subform. The box is populated by a query. Is it possible to lock the combobox (to keep users from changing the source data value) but still allow the user to select a change in the combo box from the pulldown list? As of now, the lock...

How can I "block the user from changing the data in some (or all) fields"? That sounds like exactly what Im looking for. Thanks, pmkieffe

Hi, I dont know if I am asking this in the correct way but is there any way to "lock" values from the tables? The forms and reports will be used by other users and I would like to have them only select values from combo boxes, not be allowed to type a new value or overwrite an old value...

Hi, I form with comboboxes. The user selects an entry from the combobox and with the on click event of a command button, the combination of combo box entries is saved as a row in a new table. I would like three of the comboboxes to remain on the selected value until the user changes the...

How would I use the combobox as a criteria in the subfrom's query? The use of the AfterUpdate event makes sense, but I do not understand using the criteria. Thanks, pmkieffe

Perfect. Thank You very much. That problem was starting to annoy me haha. Works great now. Thanks -pmkieffe

Hi, Can someone help me with a problem of linking subforms to forms? I have a subform which I am trying to connect to my main form. I would like to select an entry in a combobox in the main form and display information related to that entry's ID in the subform. When I try to link Master...

I dont know if this helps, but with =cboJobs the first column is displayed correctly. -pmkieffe

Good suggestion but I still get the #Name? error with col(0) Are my data types mismatching somehow? -pmkieffe

I have tried =me.cboJobs.column(2) and =me.cboJobs.col(2) in the control source for the text box. I continually get a #Name? display in the text box. Am I doing something wrong? Thanks, -pmkieffe

Did you check your Data Types of the fields you are using in the table design view? -pmkieffe

Now I get a display in the text box of : #Name? Any thoughts? -pmkieffe

Thanks Randy, but when I enter your code, I receive a syntax error. Am I doing something else wrong? -pmkieffe