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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Has anyone used a stored procedure with a continuous form?

Status
Not open for further replies.

KillerChairs

Programmer
May 5, 2005
4
US
I have written a TimeSheet application using a continuous form. Each line in the form has the following fields:
hidProjectNumber (bound fld)
hidComments (bound fld)
hidStartTime (bound fld)
hidEndTime (bound fld)

txtProjectNumber (unbound fld)
txtComments (unbound fld)
txtStartTime (unbound fld)
txtEndTime (unbound fld)

I would like the form set up so the user doesn't have to click on an Edit button to take him to another editable form to update the fields. I've tried to hide the bound fields and then populate the unbound fields with the CurrentRecord's data. The problem is that every unbound field gets the data of the CurrentRecord, i.e. the txtStartTime fld is the same for every record on the screen. When I tab to the next record, ALL of the unbound flds have the CurrentRecord's data. I tried to hide the
Non-CurrentRecord's unbound flds, but that didn't work either.

Any ideas?



 
How about conditional formatting and Field Has Focus? The text colour could be set to match the background, except when the field has focus. [ponder]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top