Hi I've got a bit of a problem.
I need to be able to create a form which need to contain some kind of list function for dates etc. The problem is that i need to be able to insert new data in that same "listbox". How can i do that?
My table companyname which has a one to many relationship with rednr
needs to be able to look up all the rednr and add them to a list in a form.
But I need to be able to insert new rednrs in that list aswell.
I dont understand where I should input that me.mylistbox.requery row and so on.
What I want to do is this:
Make a form where the user inputs a company name etc,
Then i need to have a list of the rednrs thats connected to that companyname, but I want it to be possible to insert new rednrs in that same form. How do I do that?
I tried making a form with a subform that contains the rednrs. The problem with that is that I can't insert new numbers without having to make a column with the companyname next to it.
I'd like to be able to input new rednrs in the subform without having to insert the companyname everytime.