text not saving to table

[mkelly]

I have a text box on a form with the coomand "=[formname].[form]![fieldname], this box is populated when the subform autonumber textbox populstes. But it will not save the value to my table. Does anyoneone know how to make it save the value to the main form table??

 

[WayneRyan]

mkelly,

When you have your form in Design View, does it say "unbound"?

To save it to a table, it's ControlSource must be set to a field in the
form's table or query.

Wayne

 

[mkelly]

mkelly,

When you have your form in Design View, does it say "unbound"?

To save it to a table, it's ControlSource must be set to a field in the
form's table or query.

Wayne

it does not say unbound. If I set my control source to boxnumer on the records table how can I have the box number on the subform populate the fiels on the form and in the table??

 

[WayneRyan]

m,

I'm way confused here.

It sounds like you want a field in your subform to have
the same value as a field in your main table.

Or, maybe you're trying to have a subform drive the main
form.

That's not a good thing.

Need more info here ...

Wayne