Could any of you please show me how to create a form that can send data to a table and retrieve data from another table (similar to query) concurrently.
For example: I have tbl_Info that keeps a list of information on companies (ticker, company name, EPS,...) and I also have tbl_Comments that keeps my comments about the companies (ticker, dateinput, comment).
I would like to create a blank form, frm_Comments, linked to tbl_Comments so that when I put a ticker in the Ticker control, and my comments in the comment control, this table can also pull in the relevant company name from tbl_Info.
I can easily creat a query that is driven tom the ticker control on frm_Comment to get the data from tbl_Info, but I would like to be able to get the relevent results from this query to show up on the frm_Comments.
Thank you so much in advance for taking the time to help me! Regards, Tim
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar