form help! not able to add values and want to copy previous values

[geekdom jester]

Hi, I have an access db that is going to be used by laborers. it is a field report of how many people showed up at work, what the weather was, etc.

i am having problems with it.

1. i have subforms and while the subform is allowin me to add rows to it (new record), the main form doesn't. it's stucked to 1.

2. when the laborer in charge does the daily report, he wants to be able to have a button to click and the day's report will be pre-filled by yesterday's report as there would be limited changes to it. how do i do this? is there a code to copy the previous record to the new record?

thanks so much.

confused geekdomjester

 

[Liv Manto]

Create a query, criteria is = date today minus one day.

 

[geekdom jester]

thanks liv,

but how do i get those query values into the control?

say for example:

cmbSkyCondition is populated by a value list that has clear, rain, fog, snow on it. if i query the day before, then how do i override the value list?

is this right?

me.cmbSkyCondition.value = qryDayb4.SkyCondition.value

thanks.

btw, i grew up in manila

 

[BLeslie88]

actually...

me.cmbSkyCondition.RowsourceType = Table/Query

me.cmbSkyCondition.Rowsource = SELECT MyTable.MyFields FROM tblMyComp Where MyTable.Date = MyTable.Date - 1;