How to auto populate fields from another table within a related form?

[ayupchap]

Hi there hope you can help

I have made a very simple access database which allows the search of a customer (or seller as we call them) for a record store. This then generates a transaction which in turn allows you to list the items they are buying, this can be seen in the screenshot I supplied. I have two things I would like to achieve firstly within the Record sales transaction object how can I get the details to auto-populate when the stock ID is entered (which is the key field)?



Secondly if you look at the customer details for sales form how do I make that not in a grid view and just a single area like the customer_id and names above it or at least make it look more like that?


Sorry not the best at Access and this is early design days but it is coming together and working and help with this would be amazing.

[Perceptus]

part1
If Me.RecordNew then
me.fieldyouwishtofillinitially = fill with information you want.
end if

part2
set the style of the window display from Datasheet to Form View. to get it out of datasheet. you may be able to right click on the subform and switch it to this. If you cannot, check the Formatting Tab for Allow Form View.

[ayupchap]

Thanks so much for the reply!!! I have to be honest though and say I am not sure where I type this in. The data is coming from the same record. Where do I complete part 1? Sorry to sound so neewbie but I've never done this before in Access.

[Perceptus]

for part1, you would want to put that in the Form_Current Event.

[ayupchap]

Hi there

So I have managed to get the auto-populate to work - YAY! but now I am having other problems unfortunately.

For example when I save a record it seems to be messing up another table and also when I add a new record it changes the previous one. Let me try to explain this.

When I create a new record and add a new stock ID, it changes the record aboves stock ID to the same one which causes an error.





Also this happens where it creates a new product record




I am not sure what is going on or why this is happening, if anyone can help please let me know. I am happy to upload the actual access database as it has no private data in it yet.