Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-26-2014, 09:27 AM   #1
keen1598
Newly Registered User
 
Join Date: Nov 2014
Posts: 13
Thanks: 7
Thanked 0 Times in 0 Posts
keen1598 is on a distinguished road
Query to load data into and save data from text-boxes on a form

Hi All,

This is really a two parter: I need to first figure out the best way to save data to a table using the form format I have built, using unbound fields, and also how to load data from a table into those fields after selections have been made and when a control button is clicked.

I have a form and table which I will be using to enter data into, and also load data from (in the event a modification needs to be made) which I've attached below.

Basically I need to filter by month, year and the unit each field corresponds to using a string, compared to the month and year selected in the form to load data when my control button is clicked.

My caveat is that I do not want to use vba. My goal is to run a sql query on click activation to load the form. I tested setting the record source to a dlookup value, but when the month and year changed, the form froze, and started flickering while calculating the end result. filtering for 3 fields through 5000 records bogged down the pc.

The second piece which I think is probably the easier part, is to create a new record for the month and year for that unit and save the five textboxes to their respective fields using the month and year from the drop down selections.

Any help is appreciated. Thanks
Attached Files
File Type: zip HAI PROJECT RENEWED.zip (190.3 KB, 50 views)

keen1598 is offline   Reply With Quote
Reply

Tags
form , load , query , save , textbox

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Function to pull data from a query into text boxes on a form ritco Visual Basic 0 09-05-2012 06:13 AM
Make data input into form from comboboxes, text boxes etc write to table whitelockben Forms 7 10-09-2011 06:38 AM
Update info text boxes based on combo boxes on data entry forms Saracen Forms 6 05-24-2011 08:08 AM
Can you edit text boxes in a form that gets its data from a query? swarv Modules & VBA 11 12-12-2008 09:59 AM
Help! Load query data and output to form? How? ray147 Modules & VBA 1 12-16-2005 06:59 AM




All times are GMT -8. The time now is 08:00 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World