Form Record Source

[Samuel]

Hi

The form source used to be a table then at a later stage I set a query to be
the record source. Now the client is complaining that when many users open
the same record it loses that record (this suggestion is not proven)

Can the change of the record source be related to the problem that they
experience now

Thank you,
Samuel

 

[Allen Browne]

Using a query as the source for a form is not a problem.

If you have not already done so, split the database so that each user has an
independent copy of the front end. If that's a new idea, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

If each user already has a copy of the front end, you might want to see if
there is anything in the query or in the events of the form that could cause
the problem. For example, is there anything in the query that depends on the
form, e.g. [Forms].[Form1].[Text0]. If the query depends on the form for its
critiera, and the form depends on the query, you could have a cyclic
relationship that causes it to mess up as it loads.

If the query is fine, there could be a problem in the form's events.
Particularly Open, Load, Current, or Timer, could be suspect.

 

[Samuel]

Thank you,
Samuel

Using a query as the source for a form is not a problem.

If you have not already done so, split the database so that each user has
an independent copy of the front end. If that's a new idea, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

If each user already has a copy of the front end, you might want to see if
there is anything in the query or in the events of the form that could
cause the problem. For example, is there anything in the query that
depends on the form, e.g. [Forms].[Form1].[Text0]. If the query depends on
the form for its critiera, and the form depends on the query, you could
have a cyclic relationship that causes it to mess up as it loads.

If the query is fine, there could be a problem in the form's events.
Particularly Open, Load, Current, or Timer, could be suspect.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi

The form source used to be a table then at a later stage I set a query to
be the record source. Now the client is complaining that when many users
open the same record it loses that record (this suggestion is not proven)

Can the change of the record source be related to the problem that they
experience now

Thank you,
Samuel