form wont display due to query requirement.

  • Thread starter Thread starter Andre C
  • Start date Start date
A

Andre C

The database holds client information in one table and a list of when
they are visited in another table.

A form is used to input the details of the visit. This was working
fine and then I added a refinement.

On the form I want a field to be displayed which shows how often the
average that the person has been visited in the last 3 month. A
seperate query generates this, linked via a unique client number.

I place the field (visitavg) on the form. If I just scroll through the
current data with teh input form, all is fine. However if I open the
form in add record mode the form is blank, no controls visible. If I
click on an add record button I get a message that "that option is not
available at present."

I am presuming this is because when I open a form in add record mode
there can be no result from the average visit query. How can I resolve
this.

Andre
 
Consider using a subform or other method for the average so it isn't bound
to the record source of the main form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open a form with TABS from another form 1
Separate Form 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Recordset Not Updateable message 2
Form/Subform link 3
Add new records into source table on Form 8
Copy record info into new form 0
Can a form linked to an autoLookup query update another table 1

Back
Top