Help if Possible

[dosgimp]

Hello and good morning all that read this..

Not sure how to ask this. So I will try to as blunt as possible due to frustration.

How the heck can I have a few selected form fields auto populate from a sub forms data.. due to it being and staying the same..

its a 3 stage thing. order trails to 3 diff people. each people adding new information . but some information stays the same... however each stage has its own table..

Hopefully I have explained this well..

 

[Rob.Mills]

I'm a little confused by what you're saying but every textbox has a default value property. Will that take care of your problem?

 

[dosgimp]

its basically like this i have 3 tables scheldule. ship bill. each table has its own form. each table has some of the same fields.

Its starts with one form that starts the order. of how many what kind where whom etc..

would I would like is really 2 things. the next form (ship) to get the same information from the table prior - (schedule) but not as displaying it like a sub form would. but to auto fill the information in the fields itself since this is a seperate table. is this possible?

then I would like to do this again on the 3rd form (bill) but that form will need to get information from both schedule and ship tables. and apply it to its own.

any help at all would be great..
hopes i made this easier to understand.

 

[Rob.Mills]

Based on what you said it sounds like you need to make sure your relationships between the tables are set up good and then your forms need to be based on queries that join these tables.

Can you post your db?

 

[dosgimp]

sure buts its pretty ugly.. and not fully completed still just gettting most things to work the way i need them..

Ive up loaded the basics. I cant the whole thing..

 

[Rob.Mills]

Sorry, got mixed up with some other things. Alright I've got your db open. Where do I start?

 

[dosgimp]

umm pretty much. i just need the fields on supstuff from to filled in from the data from the loading summary table..

Carrier
Destination
Location

 

[Rob.Mills]

In the first form where it opens the next form setup code to first open the form and then you can set the field values to equal the current form. Here's an example to follow along.


Private sub

Dim frm as Form

Docmd.OpenForm "2ndForm"

Set frm = Forms!2ndForm

frm!textbox1 = Me!textbox1
frm!textbox2 = Me!textbox2
etc...

 

[dosgimp]

will both forms have to open for this to work? and will the information from the forms be adding into the table's record?

or is this just display..

on the sup stuff form disregard the sub form. I dont want to have with the this finish product

 

[Rob.Mills]

Well the first form needs to be open to call the sub. But at the end of the code you can write a line to close the first form or hide it.

If the 2nd form is bound to a source then it will be added to the table. You might want to write a line in to have the 2nd form move to a new record before you set the values. Or if the form's going to be strictly for data entry then you can set its data entry property to true.

 

[dosgimp]

well great i will keep toying around.. Thank you again for all your help.

any other suggestions?

 

[dosgimp]

where can i find this data entry option?