Can I bind a text box on a form to a field in an open table

R

Robert

Imagine two tables: one a basically-descriptive Asset identifier and the
second with periodic Prices for the assets. Given a simple one:many
relationship, the table view of the Asset table nicely expands/collapses to
show the relevant prices. Would like to select a record from the nested
table and instantly show a graph of price-time.

I'm open to alternatives (keeping in mind the simplicity/elegance of the
Asset table view is important to me) but I currently imagine an unbound
[Pop-Up] form that contains only an AssetID field and an imbedded graph
(where Master Field is AssetID), and where the Control Source for the AssetID
field is the then-current record on the Asset table (even better if I can
eliminate the AssetID field and have the Master Field for the graph simply
look to the table).

Currently the graph runs perfectly when I manually paste or type the AssetID
into the field on the graph form. MY QUESTION is whether I can reference a
particular field in a table as a Control Source for my text box.

Regards,
Robert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter a child field combo box? 7
bind a text box with an expression to a field in a table 3
Using DSUM to get running total on a filtered form 0
Data entry for a table from a form 2
Adding a field from another table on a form 2
Image control on form - not displaying the image stored in a file 8
Can a form linked to an autoLookup query update another table 1
DCount Records to Display in Form 9

Top