Hi All,

I am busy with a very simple database. I have 5 tables in which the
relationships are on a one to one basis. I am trying to create a form
with tabbed pages so that I can input data destined to the 5 tables.

I had to create a query in order to bind the form to all the tables.
No problem there. When I input data, it is inserted in the tables
correctly, but if I close the form and re-open it, there is nothing in
the fields. The tables still have the information captured previously.

Could someone please shed some light on this one?


Thanks and regards

GB

Have you perhaps set the form's DataEntry property to True?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"bosco555" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
>
> I am busy with a very simple database. I have 5 tables in which the
> relationships are on a one to one basis. I am trying to create a form
> with tabbed pages so that I can input data destined to the 5 tables.
>
> I had to create a query in order to bind the form to all the tables.
> No problem there. When I input data, it is inserted in the tables
> correctly, but if I close the form and re-open it, there is nothing in
> the fields. The tables still have the information captured previously.
>
> Could someone please shed some light on this one?
>
>
> Thanks and regards
>
> GB
>

It's quite simple in MS-Word. Go to Tools, Options, Cutomise and take off
the over typ seclection. In Access it's not so simple (microsoft please take
note ??). On a form you can turn it off "quite" simply.

Creat a form and name a text box (Text 1 - or what ever you want) then click
Properties and select Event and "on key press". Create a vba (the 3 little
dots) and insert this bit
Sub Text1_KeyPress (KeyAscii As Integer)
If KeyAscii <> KEY_BACK Then
Text1.SelLength = 1
End If
End Sub
I have assumed that you have name your box "Text1" but this could be
anything you want. (Dont put spaces in the box name).

Hope this helps




"bosco555" wrote:

> Hi All,
>
> I am busy with a very simple database. I have 5 tables in which the
> relationships are on a one to one basis. I am trying to create a form
> with tabbed pages so that I can input data destined to the 5 tables.
>
> I had to create a query in order to bind the form to all the tables.
> No problem there. When I input data, it is inserted in the tables
> correctly, but if I close the form and re-open it, there is nothing in
> the fields. The tables still have the information captured previously.
>
> Could someone please shed some light on this one?
>
>
> Thanks and regards
>
> GB
>
>

Sorry pasted this into the wrong question. should have been below. Sorry

"Douglas J. Steele" wrote:

> Have you perhaps set the form's DataEntry property to True?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "bosco555" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi All,
> >
> > I am busy with a very simple database. I have 5 tables in which the
> > relationships are on a one to one basis. I am trying to create a form
> > with tabbed pages so that I can input data destined to the 5 tables.
> >
> > I had to create a query in order to bind the form to all the tables.
> > No problem there. When I input data, it is inserted in the tables
> > correctly, but if I close the form and re-open it, there is nothing in
> > the fields. The tables still have the information captured previously.
> >
> > Could someone please shed some light on this one?
> >
> >
> > Thanks and regards
> >
> > GB
> >
>
>
>

Are you saying that the data makes it into the tables via your form? But
when you close and reopen the form, the data in the tables doesn't show in
the form?

Why do you want it to? It sounds like you are using the form for data
entry. Do you also wish to use it for editing existing data?

Check the properties of the form -- the Data Entry property may be set to
Yes.

--
Regards

Jeff Boyce
<Office/Access MVP>


"bosco555" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
>
> I am busy with a very simple database. I have 5 tables in which the
> relationships are on a one to one basis. I am trying to create a form
> with tabbed pages so that I can input data destined to the 5 tables.
>
> I had to create a query in order to bind the form to all the tables.
> No problem there. When I input data, it is inserted in the tables
> correctly, but if I close the form and re-open it, there is nothing in
> the fields. The tables still have the information captured previously.
>
> Could someone please shed some light on this one?
>
>
> Thanks and regards
>
> GB
>

Hi All and thanks for the replies,

Yep, I will be using the form for data entry and for editing existing
data, so I would need to see the existing info in the form. I was able
to do that in the previous accesses namely 97 to 2000??? I had a whole
database created in Access97 dedicated to vehicle tracking (trucks,
from factory to client, services etc.) but that was many, many moons
ago.

Can I have the form performing both functions: input and edit/browse
existing records in Access2003??

thanks again to all for the help

regards

GB

You didn't answer my question as to whether you've set the DataEntry
property to True. If you have, set it to False.

All the DataEntry property does is determine whether existing records are
displayed: it has no impact on whether or not you can add new records or
change existing ones. The form properties that control that are AllowEdits,
AllowDeletions and AllowAdditions. (and even that isn't a guarantee that you
will actually be able to make changes: if the underlying recordsource isn't
updatable, your form won't be able to make any changes)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"bosco555" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All and thanks for the replies,
>
> Yep, I will be using the form for data entry and for editing existing
> data, so I would need to see the existing info in the form. I was able
> to do that in the previous accesses namely 97 to 2000??? I had a whole
> database created in Access97 dedicated to vehicle tracking (trucks,
> from factory to client, services etc.) but that was many, many moons
> ago.
>
> Can I have the form performing both functions: input and edit/browse
> existing records in Access2003??
>
> thanks again to all for the help
>
> regards
>
> GB
>