This has to be easy!

[fixemup27]

Folks what am I missing. I have a form setup in Access (split form). When I import data into a table (which the form was made from) I would like it to populate the bottom section of my form. I would like to do this via button, so there has to be some action to call the information populated in the table to place it into my form so that it can be reviewed. I feel like this was the whole purpose behind a database, but I cant seem to find a way to assign pulling information fromt the table into the form by way of button. What am I missing!

 

[mdlueck]

So is the question getting data from "some outside source" into the database table, or to get the form to requery/refresh and display new data which has been added to the table since the form first opened? The solution to those two questions are totally different.

 

[fixemup27]

I figured it out it's "showallrecords" macro..Thanks..its was retrieving data from the table to the form.