Access .adp

[NewGuy2006]

Hi there

I am a new user to .adp and am trying to develop a front end that will allow users to input data via a form and update the SQL tables.
However I have tried to create the form and in design view everything looks fine but the minute i view the form its black nothing appears but the background colour can anyone point out what I am doing wrong of even if it is possible to create a data entry form in .adp linked to SQL.

Many Thanks

 

[Pampers]

Probably your front end isn't connected to your backend, so no data will be retrieved and forms remain empty.

Pampers
You never too young to learn

 

[NewGuy2006]

Do you mean the front end not connected to SQL prbably because it seems fine on that front.
Its purely when I try to view the form after I have created it and saved it

 

[Pampers]

Can you view your tables and what is in it?

Pampers
You never too young to learn

 

[NewGuy2006]

Yea I can see the tables and whats in them and when I am designing the form it looks ok the minute I view the form or save and open it its just the background

 

[Remou]

Is your form based on a query, and if so, does the query return any records?

 

[NewGuy2006]

No the form is not based on a query
Does that mean I have to create a update query which I then use in the form to input values into the table?

 

[Remou]

I don't think so, it's just that if there are no records to show and the form does not allow additions, it will be blank when opened.

 

[NewGuy2006]

So How would I be able to update the table using a form?

I basically need a form that can be used to input data into a table

 

[Remou]

I think I get it now, have you a Record Source for your form?

 

[NewGuy2006]

The record source would be whatever the person types into the boxes on the form ..if thats what you mean

 

[PHV]

Have you tried to follow the form wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Pampers]

NewGuy2006,
a (bound) form normaly has a recordsource, a place where the date is stored. A form is not a recordsource (datasource), more like a window to look at your data stored in tables. To give your form a recordsource, you create a table with the different fields/variables. Then you bind this table to your form.

You can do this by using the formwizard, who asks on what table/query the form has to be based upon. Or, if you already have a form, double click the upperleftsquare of the form. You now see the properties for the form. In the property Recordsource, use the dropdown to select your recordsource. If you are a beginner, you probably use a table. But you can also use views, stored procedures or straight Trans-SQL.

Pampers
YThere are only one way to change a diper - fast

 

[NewGuy2006]

Sorry for the long time to reply.

I have tried to use the wizard to create a form to the table but I just end up with a msg saying this Recordset is not updateable
any idea how I can change that?