Search results

Ive dun this: Private Sub NoOfBoilers_BeforeUpdate(Cancel As Integer) NoOfBoilers = Me.Count End Sub it seems to work

afterUpdate code: Private Sub Combo38_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[CustName] = '" & Me![Combo38] & "'" Me.Bookmark = rs.Bookmark End Sub does dat make fings clearer?

Any1????????

It does hav this but I need a field which would "at a glance" tell me the number as it is vital information. Would me.count do?

Hey, its ok. I've figured it out now but plz try and help me with my other questions! Thanx

Hey, I need to know how to set a textbox to automatically input a value into itself. I have a subdatasheet in my form and want to be able to but into the textbox the no of records in my subdatasheet. It sounds really simple and it probably is but i am not that experienced with Access so am...

I have a database which uses 1 form to input/edit records and another form to view them (no edits can b made to it). The form used to view the records (form2) has a button on it called edit which when clicked on opens the other form (form1) so that the record can b edited. The problem i am...

Also when i go into design mode the combo box has "unbound" in it, could that b d problem?

If i do as u suggested i get an error message when i select from the list: Error msg: Update or CancelUpdate without AddNew or Edit. I then cannot exit the form as this msg keeps popping up.

I have inserted a combo box into a form - this is set to find a record based on the value chosen. This works as it shud do and displays the record when a value is chosen. The problem i am having is that when i scroll thru the records using the navigation buttons everything changes as it shud...

It made no difference, hope i did it right. I changed the properties in the view customer form. The name does change but only when i click on the arrow It looks like dis: Lets take Mute as the customer, MUTE \/ If i den edit dat to "mute" it wud look like dis: MUTE \/...

Thanx for ur reply, Im sorry but im kinda new to Access so need a bit more help plz. The form to view the customer's details is called: View Supplier Info the form to edit the customer's details is called: Edit Supplier Info On either form i cant find OnActivate on the form properties and wud...

HI, I hav a customer form which allows me to view details of all the customers in the database. A combo box is used to select the customer's name which den brings up the details of the customer. If i wanted to edit any of the details i wud click on a button which wud open up another form with...

Hi, hope sum1 can help me. I am trying to create a simple stock control system. I need to check stock levels of products. I need help in creating a field which automatically updates the product levels of items when they are ordered and sold. I thort mayb I need to create global variables but...