unable to edit on my form

[Guest]

Hi

I have many tables all joined by the same Primary Key which is an Employee
ID number (not an autonumber). Each table has many different fields relating
to each employee, such as, Table 'Travel Docs', and 'Vaccinations', and
'Contact Details', and 'Status', and a few more. I have a form for adding new
details which has tab controls with each tab containing the fields from each
table. so once the person has filled out each page as much as possible, it
will have updated all the tables related.

Then i copied the form and changed its recordsource to a select query which
i made to prompt the user to enter an ID number or Surname for them to be
able to edit those employees details through a duplicate form of the 'add new
details' form. i set all the necessary properties to allow edits with no
locks, etc.

But when i try using the form, it prompts me correctly, but shows up blank.
not just the form with empty fields, but completely blank, no form at all
except the form header. Why does this happen? is it to do with the fact that
the records i try calling up are incomplete? (meaning, not all their fields
were filled in upon adding the record)??

This is creating a big problem for me.What can I do to fix this or avoid this?

Thank you
Kind Regards
Rigby

 

[Rick Brandt]

Hi

I have many tables all joined by the same Primary Key which is an
Employee
ID number (not an autonumber). Each table has many different fields
relating to each employee, such as, Table 'Travel Docs', and
'Vaccinations', and 'Contact Details', and 'Status', and a few more.
I have a form for adding new details which has tab controls with each
tab containing the fields from each table. so once the person has
filled out each page as much as possible, it will have updated all
the tables related.

Then i copied the form and changed its recordsource to a select query
which
i made to prompt the user to enter an ID number or Surname for them
to be able to edit those employees details through a duplicate form
of the 'add new details' form. i set all the necessary properties to
allow edits with no locks, etc.

But when i try using the form, it prompts me correctly, but shows up
blank. not just the form with empty fields, but completely blank, no
form at all except the form header. Why does this happen? is it to do
with the fact that the records i try calling up are incomplete?
(meaning, not all their fields were filled in upon adding the
record)??

This is creating a big problem for me.What can I do to fix this or
avoid this?

Thank you
Kind Regards
Rigby

Multi-table queries are often not updateable. In addition, a form will appear
completely blank when it has no existing records and at the same time it is not
possible to add new ones.

If your query is constructed wrong such that it returns no rows when it should
and at the same time is a query that does not allow edits then a completely
blank form would be the expected results.