data missing in 1 field only

[richrich]

Hi,

I have a form that collects data, it works perfectly and writes all inputted data to the table. I have made the same form but using the data web page wizard.

It works fine but when i look at the table, some of the data is missing. there are 12 fields to complete, (all drop down boxes) I have one table which contains the employees ID number and name.

When the id number and name and picked from the drop down box on the web page, they are listed and fine. The record gets added and no problem.

However, go an look at the data in the table and for some reason the employee ID number is present but the name field is blank?? It has not copied the data across.

Even more confusing (currently a test system) if i delete all the data in the table, it works for the first entry, i.e the web page populates the name field but only for the first entry. After that the name field remails blank.

Any suggestions? I have already deleted and re added all the table fields that relate to name and id number and still the same error. I have used the wizard to make several pages and the same problem with all of them. I am baffled why it just refuses the one field and all the others are fine.

thanks

 

[statsman]

Right click the text box on the web page and click on Properties.

Make sure the text box has the same name as the field (ie. EmployeeNo rather than Text 12).