Please someone HELP ME...

[gibbyandlinhan]

Hi

Two things..
First - I have a db (access) and I have created a form (simple contact form). However when I input data then exit the form, when I go back into the form I can't view all the other forms I have completed. All the data is safely in the tables but I can't view it in the form. Everytime I go back its just a blank form - what have I done wrong ???

Secondly - Is it possible to create a hyperlink from the line in the table to the corressponding form page, so you can scan through the table then click on the line and the form with all the details appears and you can then alter..

I hope someone can help me

Gibby :-(

 

[RuralGuy]

It sounds like your form is set to DataEntry. You may now set that to No on the Data tab of the Properties sheet of the form. For the second question I think you need to have the Wizard create a ComboBox that looks for a record in your table. The Wizard will ask all the proper questions to get it to work.

 

[Smart]

Sounds like your form has been set as data entry a= yes
I would leave this as it is.
Create a new form that selects the data you want (based on the table maybe or a query) In the properties of the form :
format,default view = continuous forms
other,cycle = all records

 

[gibbyandlinhan]

Thank you but no joy

Hiya
I have tried everything but still the same

I input data into the form click forward to complete another form. All the data goes into the tables fine, however when I go back into the form I can't view any of the completed forms....it's just a blank form no record of the completed form pages
Please HELP me.....

 

[jrjr]

Try making a new form and see if that works. Right click your table and choose save as. Then tell it to save as a form.

 

[gibbyandlinhan]

sorry no fixy problem

I still have same problem maybe I should just go have a beer and forget this whole thing - nothing seems to work. - boo hoo

 

[RuralGuy]

On the Data tab of the properties sheet of your form you should have Allow Filters = Yes, Allow Edits = Yes, Allow Deletions = Yes, Allow Additions = Yes, Data Entry = No. Is that the current configuration? Also what is the RecordSource of the form? If it is a query could you post the SQL for it? This particular problem is solvable or your system is corrupt and you need to take corrective action before proceeding further.

 

[RuralGuy]

Another thought, do you have the Navigation buttons turned on so you can move back and forth? If so, are they dimmed out? Do they show you how many records you have?

 

[gibbyandlinhan]

SELECT Contacts.*, Months.* FROM Contacts INNER JOIN Months ON Contacts.ContactID=Months.ContactID;

Is this what you wanted?

Everything else is OK

I have to say sorry now - alot of what you have said went straight over my head I am very new to this !!!

Many thanks - Gibby

 

[RuralGuy]

Are there Navigation buttons at the bottom of your form? How many records does it show you have?

 

[gibbyandlinhan]

when i am in the form and adding contacts i can move backwards and forwards
however when i close the form then open it again that's when the fun starts
i see a blank form and no other entries
all the previous entries are in the table nice and safe
any the wiser !!!???
Thanks - Gibby

 

[RuralGuy]

When you go back in, how many records does the Nav buttons show you have?

 

[gibbyandlinhan]

1 (one)
everytime
The table gets updated but i can't view them in form view

 

[RuralGuy]

Is there any code behind the form? You might try what JrJr suggested and "Save As" a new name and try the new form and see if the results are the same.

 

[gibbyandlinhan]

i will try first thing in the morning it's 1am here in China !!! must go to bed - many thanks for your help I hope your advice will help me get it sorted

Many thanks - Gibby

 

[dsetiadi]

My guess is that you created a form that corresponds to many tables, but the other tables are not related with this form in subform mode. Thus, what happens is that your other table's primary keys now contain Null value. And when you didn't complete inputting the form, the result is that those primary keys are now Null. Try to complete the form when you input the data, and see if you could see the data you just input.

A trick so that you can always view your data even if you didn't finish inputting data in the form:
1. Create one or more textbox/es (depending on how many other tables that this form correspond to).
2. On the control source, grab the value from the tables that the form correspond to
3. If you don't want to see the textbox/es, in the format properties, set Visible to 'No'

4. After you're done with this, choose one field that has the primary keys related with the other tables.
5. In the properties, After update, use visual basic:
Me.othertable1related'sprimarykey=Me.maintableprimarykey
Me.othertable2related'sprimarykey=Me.maintableprimarykey
...
...
depending on how many tables that this form correspond to.

Hope this doesn't confuse you.

Dedi