p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Language (http://p2p.wrox.com/forumdisplay.php?f=100)
-   -   Set form.field default value based on entry in another form (http://p2p.wrox.com/showthread.php?t=78158)

rmccafferty February 11th, 2010 03:29 AM

Set form.field default value based on entry in another form
 
In a date field in an Invoice form, the user enters a value. Then they move to a Line Item form which also has a date field.

How can I get the date field in the LIneItem form to default to the entry in the Invoice.Date form-field?

The system is set so that the user makes entries in the Invoice form and then a button opens another form for the LineItem entries. Thus, when the LineItem form opens, the Invoice form will be open and a value will exist in the Date field which I want to be the default in the Date field of the LineItem form.

Old Pedant February 11th, 2010 07:20 PM

Pardon me, but how is this a SQL question???

There is no such thing as forms in SQL.

Are you really asking about Access, perchance?? If so, you should ask in the Access forum. Access is not just a database; it's also a form and reporting system, but in ways that have really almost nothing to do with SQL.


All times are GMT -4. The time now is 10:32 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.