Recent content by chansda

Thanks much missinglinq! Worked out perfectly!

Thanks Statsman! So, I gave it a shot and inserted as instructed ... Private Sub Combo55_BeforeUpdate(Cancel As Integer) [Text119] = ([Combo106],2) End Sub .. but got the following error "Complie error: Syntax error" Your thoughts?

In my form "Transmit," I have a combo box that obtains values for a user to select from a table called "Merge." When the user selects a perticular value (in this case "XYZ Corp" from my "Merge" table) in the combo box, I want another text box or combo box (not sure what to use to accomplish my...

I'm not a programmer and I'm fairly new to MS Access. I've started a database to track part numbers. A sample part number is 16352 or 1423. I created a query to calculate the number of part numbers for each specific part number. For instance, in my query "Number of Parts," I have 2 columns...

In my table, I have a number field set to Index (dups OK). I have another field that I do not want to index but need "no dups." Any ideas?

HELP PLEASE!!! There are two fields in my form that need the following relationship: 1. When I enter 1000 in my "spec no" field in my form, I need my "Number Field" to enter a "1" 2. When I enter 1000 in my "spec no" field in the next record, I need the "Number Field" for this record to enter...