adding new record using a pop-up form

[lamarrgodwyn]

Hello I'm working on a database that has a subform which pulls its data from a table and I'm trying to use a popup form to enter the data in the sub form. For example the table is called student debts. The form is called student debt. The pop up form is called student debt entry from. I want the inform that's in the student debt entry form to be recorded in the student debt form which is a subform on the main form. I know i have to create a add new records button to do it but not sure of the code.

 

[lamarrgodwyn]

I just wanted to give some clarity on my previous post. I have data base the tracks student debts. The main form has three tabs. The third tab (Student Debt) has 2 subforms. (Student Debt & Paments) I have a button on the student debt tab that opens a popup form called student debt entry form. The student debt entry form has has a add records button. I would like this button to add the information entry into the form to the student debt subform and requery the form. I have been successful in using the add record micro to add the data to the student debt table. However it will not requery the student debt subform unless I click off the data and click back. If any one can help me with this I would greatly appreciate it. I'm kind of new to access.

 

[Mihail]

Unable to open your DB.
Convert it in a previous version (2003 or 2007) of Access.

 

[lamarrgodwyn]

Unable to open your DB.
Convert it in a previous version (2003 or 2007) of Access.

I tried to save it as an earlier version, but it will not allow me to. I shold have been able to got o save database as and select it in the drop down. However it did not have any other options there to convert it.

 

[pr2-eugin]

I tried to save it as an earlier version, but it will not allow me to.

That's because you have special features like Attachments, Lookups in your table design. I am not in a good position to look and decipher your design (ATM), but use this link to refer to the correct subform : http://www.btabdevelopment.com/ts/ewtrhtrts

Then use Requery AND Refresh.