By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,140 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,140 IT Pros & Developers. It's quick & easy.

access record overwritten

P: n/a
Hi,

I have found to my distress that my newly created printer consumables
database is overwriting exisitng records when i search my printer
history form.

Basic i have a form that have a combo box selects a printer record.
The 'task' history of the printer record is then displayed in the
subform ' printer history sub'.

Also i have 4 text boxes than update 'on change' using the following:
Forms![printer history]![Text35] = Forms![printer
history]![Combo33].Column(1)
Forms![printer history]![Text37] = Forms![printer
history]![Combo33].Column(2)
Forms![printer history]![Text39] = Forms![printer
history]![Combo33].Column(3)
Forms![printer history]![Text41] = Forms![printer
history]![Combo33].Column(4)

The text boxes supply information on the printer_id record selected in
the combo box.

This form works fine until the middle scroll wheel on my mouse is
flung round at any speed.
The printer_id field appears not to change (and the drop down list
does not appear) during this however the four text fields update with
scrolling.(the subform does not change either).

When i return to the table i find that entries have altered to records
from other records.

I have locked the text boxes so that they cannot be ammended.

Weird and highly distressing!! Any suggestions....

A better alternative might be being able to show all printer details
in the combo box rather than just the printer_id (a record generated
number) thus i would no longer need the four text boxes.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.