Search results

I've tried this too: If Me.cboRate = Rate1 Then Me.txtCost = DLookup("Rate1", "tblItem", "ItemID=" & ItemID) If Me.cboRate = Rate2 Then Me.txtCost = DLookup("Rate2", "tblItem", "ItemID=" & ItemID) If Me.cboRate = Rate3 Then Me.txtCost = DLookup("Rate3", "tblItem", "ItemID=" & ItemID)

I have a combo box in a sub form with three values, rate1, rate2, and rate3. I have another three fields in the sub form rate1, rate2, and rate3. The rates are dependent on the item. When I select the rate from the combo box I want a cost field to update on change to the relevant rate. I...

Got it working I needed to change the query. I needed to change the customer id source from the customer table to the invoice table. ^^ Thanks for your time though RuralGuy, your an asset to this community.

I want to be able to have custom ids.

relationships:

Thanks for taking a look at it, do you know how I would go about trying to solve this problem? I created three invoice entries and I've tried changing the record source to the query but I still seem to get it working.

When I try to select a different customer id from the combo box in the main form it won't let me and it makes a pinging noise. May there be a problem with the main query?

I created the form from a query made up from all the tables, but when I look at the record source for the form it lists the tables. The invoice form.

I used the to wizard to create the combo box, I don't think there is a third option, Access 2013. (I tried creating the combo box in 2007 but it didn't work) Could it be the relationships, main query, or main form properties?

In my main form I have added a combobox and changed the source properties but the customer details aren't autopopulating when a customer id is selected. http://s000.tinyupload.com/?file_id=05702272457269833949

When setting up the relationships I know that if you want to have different rates you can have the rate as a foreign key but what if the rates are dependent on each item (each item has multiple rates)? How would I set something like this us up? Thanks.

Is there much of a difference between Access 2007 and the newer versions, except for the ribbon?

Fantastic! :cool:

These are old exercises that I'm going over for practice, they aren't going to be submitted in class. I'm covering previous work because as the saying goes "practice makes perfect." Sorry for the confusion and I don't mean to offend anyone.

It's last years work, it isn't actually going towards a grade.

That thread is for the manual way, this thread is for the automatic way. (btw g2g ttyl)

Last year we had a database assignment with 5 scenarios to choose from, I'm doing the other scenarios I didn't choose now, so yea it was part of an assignment. BTW Thanks for all your help RuralGuy.

I want the IDs to be PKs and I want the IDs to have a specific format.

Solved: :) Private Sub txtCourseID_BeforeUpdate(Cancel As Integer) If DCount("*", "tblCourse", "CourseID='C" & Me.txtCourseID.Value & "'") > 0 Then Cancel = True MsgBox "This Course ID is already being used." Me.txtCourseID.Undo End If End Sub The "C"000 input mask must have been...

It returns 001.