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!

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

Additional Row in Subform

Status
Not open for further replies.

3063

Technical User
Jan 17, 2003
63
US
I have a form with a subform in it that automatically adds a row and then the field that has a % field or number field automatically inputs either a 0.0% in the % field or a 0 in the numeric field. It's causing my queries to show incorrect data. I have no default settings in my table nor my subform for it to default to this. I also checked under tools, Option, Keyboard and have it set to "Move after Enter" to "Next Record." Does anyone have any suggestions on how I can prevent the field with % and numeric field from being filled in.
 
You should be able to open the subform independently of the main form. You can then set the properties of the field to prevent it being used, tabbed to etc. You may also wish to change it to a label
 
I changed the properties of that field as you suggested and it skipped that field, but what I'm actually trying to accomplish is to stop it from adding another row in my subform and then stop adding 0.0% in the field that has a percentage field.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top