View Full Version : Form Design


kdonnel1
08-03-2000, 09:44 AM
I have a form that is getting data from a table. The form can be used for either data entry or to view the records from the table. The form has the ability to give all the associated information about the primary key (i.e. everything else in the record). For example: If I type in Item Number 715 (Item Number is my primary key) all information in the record "715" comes up in the correct fields in my form. However, if I type in a new Item number (for data entry -to create a new record), the associated information for 715 still stays. You can type over the information and save the new record but it can be confusing because it looks like all the other fields are already filled in. Is there any way I can get it to clear out and show blanks for a new record?

Travis
08-03-2000, 11:40 AM
Yes you will need to clear them prior to the new data being filled into their fields or at the same time by setting the fields to Null.