Form

[Guest]

I have a form based on a query that uses 3 joined tables. The auto number
field for this form is Service Call Number which helps with a new form being
created for each call completed.

Typically these Service Call Numbers are created by others and when the user
completes a servce call they enter the service call number and fill out a
form.

I would like to create a form for the users to complete when a call is
completed that was not previously created for them and be able to auto fill
fields that exist in the database already. This would include Account Name,
Policy Number and Location information as there copuld be up to 100 locations
for each account.

Other fields will be option groups and combo boxes and no previous
information is required. I could have the users type in the Account Name,
Policy Number and Location Information but spelling could result in these
calls not being connected to the right account. Edit and find brings up one
Account and its location. I can not scroll thorugh locations.

 

[Guest]

Ok I am getting closer. I used a form and then placed a subform for the 4
location fields I needed and now you can edit and find and account and then
click in address and scroll to one of the addresses.

The problem is that this leaves me in a state of current records when I
would like to be able to create a new record at this point with the
information in the fields going to the new record and creating a new service
call number.