Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Deleted appears in fields on forms

Status
Not open for further replies.
errolf

errolf

IS-IT--Management
Joined
Aug 21, 2000
Messages
51
Location
US
I am trying to use a form to enter data in a table. The form has a button in it that first deletes all the records from the table then runs an append query that adds the records to the table for editing in the form. However when this operation is carried out "Deleted# appears in every text box in the form how do I overcome this?.

Errolf
 
Sort by date Sort by votes
Requery the form after the Delete operation. This should clear the "Deleted" from the field display.

HTH
Lightning
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BallunarCrew
  • Locked
  • Solved
ODBC Driver Struggles on new computers
Replies
3
Views
2K
BallunarCrew
BallunarCrew
renigar
  • Locked
  • Question Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
1K
renigar
renigar
lameid
  • Locked
  • Question Question
Execution Slowing on iterative generation of PDF's
Replies
3
Views
1K
lameid
lameid
Bubba002
  • Locked
  • Question Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
2K
dhookom
dhookom
atadbitslow
  • Locked
  • Question Question
comparing fields, one populated with data and one blank
Replies
8
Views
1K
atadbitslow
atadbitslow

Part and Inventory Search

Sponsor

Back
Top