Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change main datafile with form

Status
Not open for further replies.

slaga9

Technical User
Jun 8, 2007
46
CA
I have a main form (form a) which enters data into a main table (tbl a)
then I have a parameter query which filters the data by up to 6 fields and displays it in database view.

Then I have another form which displays the filtered data in its entirety (looks like the first form)

Now in the event of data changing…I need to be able to query through the DB and find the desired job and change the data in the last form and have it carry through to the table.

I'm sure their is an easy answer, but my lack of access savvy is just keeping me from reaching it.

Any help would be really appreciated!
Thanks
Sean

additional info- (currently if I go into the main tables spreadsheet view and change infromation it carries through on the forms, and if I go into the fist form and make changes, they also carry through, I'm not sure how to recreate that relationship)
 
alos...I should add
When I open the form from the database menue I can make changes to the datatable

Its just post Query in the form veiw that I cant
post Query in the spreadsheer view I can make changes
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top