Hi, I've been trying to figure out how to bound controls, specifically textboxes to columns of tables. I tried using the "Add Existing Field" feature and inserted a control using it, the screen becomes blank when i view form.
Bound textbox causes problems
Advanced Beginner
Windows 7 
Access 2010 (version 14.0)
Hi, I've been trying to figure out how to bound controls, specifically textboxes to columns of tables. I tried using the "Add Existing Field" feature and inserted a control using it, the screen becomes blank when i view form.
Last edited by LAazsx; 11-28-2010 at 09:23 PM.
Administrator
Windows 7 Access 2010 (version 14.0)
That generally means two things: 1) you have AllowAdditions set to NO and 2) there are no records in the RecordSource.
Advanced Beginner
Windows 7 Access 2010 (version 14.0)
I don't have records in may table yet. I'm making a form that adds records. Is there a way to fix this?
Administrator
Windows 7 Access 2010 (version 14.0)
YES! Set AllowAdditions to YES.
Advanced Beginner
Windows 7 Access 2010 (version 14.0)
Thanks. It works now.
Administrator
Windows 7 Access 2010 (version 14.0)
It gets easier after you have worked with it for a bit.
Advanced Beginner
Windows 7 Access 2010 (version 14.0)
Yeah. I have a project that's due in a month and our prof has just started discussing on access. Oh well. Thank again
Advanced Beginner
Windows 7 Access 2010 (version 14.0)
Hi, i want to make a "save" button for my form. Is there a way to prevent the form from writing records instantly? and how do i code the button to "save" the record?
Administrator
Windows 7 Access 2010 (version 14.0)
The Form's BeforeUpdate event *always* fires just before any record is saved and the event can be Canceled. I would create a Public Boolean variable in the Form's Class (code) module like blnSaveOK and set it true in your "Save" button code. If it is not True in the BeforeUpdate event of the Form then Cancel the event.
Posting Permissions
Reply With Quote