Updating record in table with form data

[csuebele]

I'm trying to learn Access 2007 and VB and am pulling my hair out. right now I'm just trying to write a variable to a field in a form and have it show up in the table. Basically I went to a new record and inserted a reference number in a field, but I don't know how to get the record to update so that it shows up in the base table. It only shows up after I close the form and table. How would I exit or update a record in VB?

 

[pbaldy]

If the form is bound to the table:

If Me.Dirty Then Me.Dirty = False

 

[csuebele]

If the form is bound to the table:

If Me.Dirty Then Me.Dirty = False

Thanks! I'm pretty sure it's bound to the table. I'm more used to javascript, so I'm trying to learn the ins and outs of visual basic. I'm sure I'll have lots more simple stupid questions.

 

[pbaldy]

If the form's record source is the table, and the textbox's control source is the appropriate field in that table, it is. The fact that it shows up if you close/open the form would indicate that it is. Welcome to the site by the way!

 

[csuebele]

If the form's record source is the table, and the textbox's control source is the appropriate field in that table, it is. The fact that it shows up if you close/open the form would indicate that it is. Welcome to the site by the way!

Thanks! I'm just muddling though this stuff. Seems to take me days to work out a kink. I've been using fileMaker for years, but my company is dropping that software, so I've got to learn Access.