lookup and populate Datasheet with editable selected field, save to other table

[willsnake]

Thank you sir...

But it was supposed to be empty, but I don't know why it becomes 0...

 

[bastanu]

Check the default value in the table design and the default value for the control (textbox) in the form.

 

[willsnake]

ok sir...

thank you very much....

My db is slowly progressing now... thanks to the masters here...

For now, I will be designing my report...