Calling data to a form :(

[umair434]

Hi,

I have this form which shows the different fields from a table. User enters values in the fields and it gets saved in the original table.

What i want to do is - when the user selects a particular date, the form shows the values that were entered on that day, and changes can be made to the values (overwriting the data)

I have attached the database (2003 version) here. The form I am talking about if frmemployees - unless you put your name in the employees table, the start up form won't connect to the frmemployees!!

Anyone with a clue as in how to do this? I have been searching for this solution for sooo long

please guys!! thanks!

 

[lcook1974]

Where does the user select the date range from?

i think what you want to do is look into the

DAO.recordsets

This way you form can have a record set that you can search for using a date range then look up the values to populate your text boxes.

Then you'll need to create a button that says "update" or something and put some code behind it.

Check out this link:
http://msdn.microsoft.com/en-us/library/bb243789(v=office.12).aspx

I think maybe your table structure is not normalised too.

http://support.microsoft.com/kb/100139

Hopefully some of this will help and point you in the right direction.

Larry

 

[umair434]

I have used the Now() function in the date to get todays date -
I will look into the link and see what I can comprehend, thanks!!

and i know my table is not normalized - i tried normalizing it but ended up getting more confused :/