Link form adding new records-links one by one?

[lacampeona]

Hello experts

I want to create some Link form and then inside I want to have subform where I will add links.

I want to manage
with button add link to add links one by one to the subform.

and with button delete ( if user will make mistake) I want to delete the selected record.

I manage to create something but I get stuck, is not what I want..is adding me all the time the same link, like copy function, I want to add every time the link who is selected from the folder and not adding the same link all the time

hmmmm
Is that possible? What I have to do? Or if someone has better sample to show me?

thank you

 

[XPS35]

I don't understand what the point is. If you are talking about a subform, then I expect that there are at least two tables in your database. However, I only see one. So you will have to explain yourself in more detail.

 

[lacampeona]

Hi
I am sorry I wrote wrong.
I am talking about normal form.
I wanted to say that I then also created a form in datasheet view- to add records-links ( becouse that i get confused with subform)
I am sorry.

 

[XPS35]

I'm afraid this explanation doesn't really help. I see you have a main form linked to the tblDocCertKolone table. You do not show any data on the main form, but there is a filter ([KID]=1). You will therefore only see one record on the sub form.
In fact, you only need one form to enter data: your current subform.

 

[lacampeona]

Yes I need only one form. the form that is in spreadsheet view.

My goal is:

I want that user will be able to append some links in the form. I imagine that form to be created in spreadsheet view.

The links that user will append most of the time will be in pdf format someties can be or word or excel.

I then created 2 buttons more. One to view the appended link and another button, delete button so the user can delete the entire record if he make mistake and want to insert again new link.

All that is needed becouse user will create some ID...and then he will append some documents. That documents becouse of the size will be shown as links.

I hope I now explain it better.

 

[lacampeona]

Hi Pat
Ok good idea. I didnt think about that way.

Use a text field to hold the links rather than a field defined as hyperlink.

I will try your recomendation to see what I will managed and how is working my idea.

Thank you very much again
PS: You are saving me all the time from my problems