Can I limit the number of records in a table to one and keep changing this record thru Form

[Jose]

I am new to access and so you may find my question silly. I would like to get input into a table through a form, which is used in a query to pull data from another table. Can someone help me?

[pbaldy]

Set the form's Allow Additions property to No and it won't be able to add a record.

[Dehn0045]

In addition, you could use unbound controls on a form and set Form Property --> Navigation Buttons to OFF. Here is a short tutorial that I found instructive: https://www.youtube.com/watch?v=mnWidUABYdQ

[Jose]

I need to take input into this table through a form. Then to run some queries using this information and finish the process. Next time again I need to get information through the same form and update this record in the table and do some reports based on this new input. So every time I need the form to update the record in the table, but I don't need more than one record in this table. Can I achieve this?

[Dehn0045]

If you do what pbaldy said in his response, that should be sufficient. There is nothing fundamentally wrong with having a table that has only one record. If the input is changing only slightly, then it might be useful to use a table rather than unbound controls (unbound controls are not linked to table fields).

[Dehn0045]

If you want the input to be entirely new each time, then I would go with unbound, otherwise you will need to make all of the fields NULL using code in the Form's On Load event.

[Jose]

Thank you very much Dehn, The youtube video you recommended gives me what I wanted to accomplish. Thanks a lot.