Your Name?
There are several ways to do this. The way I would choose is to create a form using tbl_Info as the RecordSource. Then add a sub form for the comments table. Set the child and master fields to the ticker field. The form wizard will do most of the work for you, but we will be happy to help.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "timdbui" <timdbui@...> wrote:
>
> 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 (2) |
Tidak ada komentar:
Posting Komentar