Listbox w/subforms

[Ernst Guckel]

Hi,

I have a main form frmEmp and a subform sfrmEmpGeneral. They are linked
via EmpID from tblEmployees. Both forms contain data from tblEmployees. On
the main form i have a listbox that alows me to select the current employee.
There are two problems that I cannot get past...

1. I cannot update data on the subform without getting the error "Data has
been Changed" Another user has eddited this record ... but once I get this
error I can continue and the data change is saved.

2. I cannot create a new record. Not even sure how. I have created a 'New
record' button but the code gives me a blank record but It does not work
right. EmpID is an autonumber field but it does not generate a new number.

I am at a loss. The allow edits and allow additions are enabled.

Any ideas let me know,
Ernst.

 

[Jim Bunton]

The concept of a sub form is generally applicable to the situation where you
want to "link" information that is in two tables (not one). An example might
be an invoice (one table) and the items on the invoice (another table)

[eg Invoices - invoiceId, invoice date InvoiceItems InvoiceItemId,
InvoiceId, ItemDescription, ItemCost.] These would llink on InvoiceId. The
main Form would be a single record form and the subform mulitiple records.

In the case you are describing:
There ar two options (at least!)
1. Use two forms - one for 'Basic' information and anothe for 'detailed'
information
[you could open the second from the first BUT don't allow edits of the
same information on each form or you will likely get the same 'error' as you
are getting now]
2. Put all the information on one form - then, write some code to 'collapse'
the more detailed information [make the controls have zero size and move
them and make them invisible and while you are doing this have in mind the
code to resize them and move them to the original positions and make them
visible - which you can put into the click event for a button on the always
visible part of the form.

Jim Bunton

 

[Jason]

I've used tabed pages to make things easier ( the tabs can contain fields of
the same table or they can contain subforms)

The concept of a sub form is generally applicable to the situation where you
want to "link" information that is in two tables (not one). An example might
be an invoice (one table) and the items on the invoice (another table)

[eg Invoices - invoiceId, invoice date InvoiceItems InvoiceItemId,
InvoiceId, ItemDescription, ItemCost.] These would llink on InvoiceId. The
main Form would be a single record form and the subform mulitiple records.

In the case you are describing:
There ar two options (at least!)
1. Use two forms - one for 'Basic' information and anothe for 'detailed'
information
[you could open the second from the first BUT don't allow edits of the
same information on each form or you will likely get the same 'error' as you
are getting now]
2. Put all the information on one form - then, write some code to 'collapse'
the more detailed information [make the controls have zero size and move
them and make them invisible and while you are doing this have in mind the
code to resize them and move them to the original positions and make them
visible - which you can put into the click event for a button on the always
visible part of the form.

Jim Bunton

Hi,

I have a main form frmEmp and a subform sfrmEmpGeneral. They are linked
via EmpID from tblEmployees. Both forms contain data from tblEmployees.
On
the main form i have a listbox that alows me to select the current
employee.
There are two problems that I cannot get past...

1. I cannot update data on the subform without getting the error "Data
has
been Changed" Another user has eddited this record ... but once I get
this
error I can continue and the data change is saved.

2. I cannot create a new record. Not even sure how. I have created a
'New
record' button but the code gives me a blank record but It does not work
right. EmpID is an autonumber field but it does not generate a new
number.

I am at a loss. The allow edits and allow additions are enabled.

Any ideas let me know,
Ernst.

 

[Ernst Guckel]

Really what I want to do is design a tab control without using the tab
control. The one built into access is limited. I have 5 command buttons and
five subforms. I then change the source object of a subform control. I
could solve the problem by having them not linked to the main form in anyway
but act like main forms in their own right. The problem is the listbox.
When you select an employee in the listbox I want to change the employee in
the subform.

Ernst.

I've used tabed pages to make things easier ( the tabs can contain fields of
the same table or they can contain subforms)

The concept of a sub form is generally applicable to the situation where you
want to "link" information that is in two tables (not one). An example might
be an invoice (one table) and the items on the invoice (another table)

[eg Invoices - invoiceId, invoice date InvoiceItems InvoiceItemId,
InvoiceId, ItemDescription, ItemCost.] These would llink on InvoiceId. The
main Form would be a single record form and the subform mulitiple records.

In the case you are describing:
There ar two options (at least!)
1. Use two forms - one for 'Basic' information and anothe for 'detailed'
information
[you could open the second from the first BUT don't allow edits of the
same information on each form or you will likely get the same 'error' as you
are getting now]
2. Put all the information on one form - then, write some code to 'collapse'
the more detailed information [make the controls have zero size and move
them and make them invisible and while you are doing this have in mind the
code to resize them and move them to the original positions and make them
visible - which you can put into the click event for a button on the always
visible part of the form.

Jim Bunton

Hi,

I have a main form frmEmp and a subform sfrmEmpGeneral. They are linked
via EmpID from tblEmployees. Both forms contain data from tblEmployees.
On
the main form i have a listbox that alows me to select the current
employee.
There are two problems that I cannot get past...

1. I cannot update data on the subform without getting the error "Data
has
been Changed" Another user has eddited this record ... but once I get
this
error I can continue and the data change is saved.

2. I cannot create a new record. Not even sure how. I have created a
'New
record' button but the code gives me a blank record but It does not work
right. EmpID is an autonumber field but it does not generate a new
number.

I am at a loss. The allow edits and allow additions are enabled.

Any ideas let me know,
Ernst.