|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 17th, 2008, 04:17 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Updating record values
If I populate a form using a query result, does that preclude me from editing
the data that is shown in that form? 
|
|
#2
January 17th, 2008, 05:10 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Updating record values
Steve,
No... as long as the query behind the form is "updateable." A query delivers a recordset... just like a table. In general use, most folks use a query as the RecordSource for their forms... as opposed to a table. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "MeSteve" wrote in message ... If I populate a form using a query result, does that preclude me from editing the data that is shown in that form?
|
|
#3
January 17th, 2008, 05:19 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Updating record values
How do ensure the query id editable? Does contatenating 2 fields preclude
that? "Al Campagna" wrote: Steve, No... as long as the query behind the form is "updateable." A query delivers a recordset... just like a table. In general use, most folks use a query as the RecordSource for their forms... as opposed to a table. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "MeSteve" wrote in message ... If I populate a form using a query result, does that preclude me from editing the data that is shown in that form?
|
|
#4
January 17th, 2008, 06:49 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Updating record values
I don't know for sure, but probably the answer is yes.
-- Dave Hargis, Microsoft Access MVP "MeSteve" wrote: How do ensure the query id editable? Does contatenating 2 fields preclude that? "Al Campagna" wrote: Steve, No... as long as the query behind the form is "updateable." A query delivers a recordset... just like a table. In general use, most folks use a query as the RecordSource for their forms... as opposed to a table. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "MeSteve" wrote in message ... If I populate a form using a query result, does that preclude me from editing the data that is shown in that form?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
