About Form and Query

[amjad]

Hi i want to design a form based on query not on single table..... ok i have
done that but the actual problem is on based on query i cannt write any thing
to control look like bydefault looked cos i want user let change some data
.... if i do with single table every thing is fine but with query where data
is coming from different tables.... thanks

 

[Arvin Meyer [MVP]]

If your query is updateable, the form will allow the user to do the same.
Test the query first.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[amjad]

hi i dont have any idea to to create query updateable as i am using sql
server as back end thanks

 

[Arvin Meyer [MVP]]

Is your View or Stored Procedure updateable? That's what needs to happen
for the Access form to work properly with editing.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access