Search results for query: *

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

Could you please guide me on how to accomplish this? When I click on the properties of the combobox it only gives me the fields of the form control source table as possible control sources for the combobox. I would like to use fields from other tables. Thanks, pmkieffe

Also to clarify: all JobID's have a different JobNumber and JobDescription -pmkieffe

Thanks for taking the time to help. I guess the best way to explain is to show you what I have: JobID JobNumber JobDescription 1 200304 Fuel Costs 2 200305 Alternate Power 3 200308 Mill Processing 4...

Hi, I hope this is just an easy quick question. Can a combo box in a form have a table control source different than the table source of the form itself? I want the form to be linked to table tblEmployeeInfo, but then select data from other tables via comboboxes. A recordset on a command...

Oh sorry, Each unique JobID has a corresponding unique JobNumber. JobDescription is unique to each JobNumber. So a specific JobID has one corresponding JobNumber. Thanks, pmkieffe