Recent content by Talon

HEy thanks a lot it worked gr8 thx

its a rather specific question and i did try search the forum for an answer but all i got was openrecordset which i tried sorry about the trouble thx.

Basically what i've done is this: PercentageEbay = DCount("[Cust_id]", "Order", "[Cust_id] = 8") * 100 / OpenRecordset("tblOrder").Count Now basically what it does is count the number of records with cust_id =to 8 in the order table. What i want it to do is then times this by 100 and divide...

What im trying to do is to refer to the total number of records in a table using count function >.< in VBA because i need to use >.< the value of the total number of records for a calculation in VBA thx

Basically MY problem is that i set the control id to that of a primary key so that when the combo box data is changed it puts the data in the table. However my problem is that the data it displays is a price and im trying to calculate a total. Therefore in VBA im trying to find out how to refer...