Unable to go to next record in form

[dsf700]

Hello,

This is probably an elementary problem to most of you,so any information you can give me would be appreciated!

Here's my problem: I created an "Application" Table which I also created a form for. As I finish entering data into the form, I want to go to the next record and start adding new information; however, the small triangle is inactive and I'm unable to go to the next record. I'm assuming I may have made a mistake in my orginal table?

Any ideas anyone?

 

[earthandfire]

Is your form "bound" to the table?

 

[dsf700]

I'm not sure (you're speaking to a real Access novice here). How can I go back to make sure the form and table are bound?

I have a few other forms that work perfectly fine and compared the tables, but I couldn't find any discrepencies.

 

[earthandfire]

Switch the form into Design View.

In the Properties window, select the Data Tab

The form is bound if you have something in the Record Source property.

If you have, make sure that the Row Source property is set to a field name for each of the controls on the form.


A quick test to see whether, at least in principal, everything works is to let Access create a form for you.

In the Database window, select your table, and then from the menu bar select Insert | AutoForm. Access will produce a from based on the table. See if you can insert multiplpe records using that new form.

 

[dsf700]

Thanks for the help earthandfire. I follwoed your advice and here's what I got:

1. When in the properties window the Data Tab is completely
blank.

2. I did the AutoForm and I still was not able to insert
multiple records.

 

[traingamer]

How about the "Allow Edits" properties on the Data Tab?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[earthandfire]

To be honest, you've stumped me. I'm afraid I haven't a clue what could be going wrong. Hopefully someone else will be able to help.

 

[traingamer]

And you have to be in the Properties for the FORM (as opposed to one of the controls) - it should never be blank.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[earthandfire]

traingamer, what threw me was that the form created by the AutoForm Wizard would not allow multiple records to be input

 

[traingamer]

That is puzzling...

 

[dsf700]

Traingamer you were right, I wasn't viewing the Form properties. Now that I have, this is what's in my record source:

SELECT [Application].[Application ID], [Application].[Household ID], [Application].[Application Time], [Application].[Application Date], [Application].[Staff Processing Application], [Household].[Address Line # 1], [Household].[Address Line # 2], [Household].[City], [Household].[State], [Household].[Zip Code] FROM Household INNER JOIN Application ON [Household].[Household ID]=[Application].[Household ID];

Do you know why my record source for this form would be so different compared to the record sources of my other forms?

 

[PHV]

Maybe your query isn't updatable.
You may try this:
SELECT [Application].[Application ID], [Application].[Household ID], [Application].[Application Time], [Application].[Application Date], [Application].[Staff Processing Application], [Household].[Address Line # 1], [Household].[Address Line # 2], [Household].[City], [Household].[State], [Household].[Zip Code][highlight], [Household].[Household ID][/highlight] FROM Household INNER JOIN Application ON [Household].[Household ID]=[Application].[Household ID];

Take a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dsf700]

Nevermind everyone,the autoform definitely works. My problem in the original form had to do with my textboxes being 'unbound'.

Thanks so much for the help!